Friday, July 16, 2004

SQL forms a good candidate for a cmdlet provider in Monad/MSH. Using something like this you will be able to browse through the database, DB tables, SPs etc as though it were a filesystem. I was thinking ways of writing a C# app to do the work, especially about connecting to SQL and getting all information besides Databases. Before I could make up my mind, I found an option to expose the SQL server group as an AD object in the AD.

 

The registry and AD cmdlet providers also come with MSH. Now since the AD provider exposes the AD as a browsable system, you should be able to browse through the SQL server on the msh commandline! Is it really as simple as that or am I missing something here. Unfortunately I don’t have the resources to test this out now.  

 

We’ll find out soon J

Friday, July 16, 2004 7:38:37 AM (US Eastern Standard Time, UTC-05:00)  #    Comments [2]TrackbackTracked by:
"New SQL Delta version 3.1" (Computer News, Information & Articles) [Trackback]
Wednesday, July 28, 2004 10:27:46 PM (US Eastern Standard Time, UTC-05:00)
Hey!!! Did you know that SQL Server 2000 can be published in the AD? This is a feature available from the SQL Server Configuration tabs. Just check out from Enterprise manager.

:)
Thursday, July 29, 2004 5:42:59 AM (US Eastern Standard Time, UTC-05:00)
Exactly what I said, I stumbled upon that option in enterprise manager and then wrote this blog entry :)
Name
E-mail
Home page

Comment (Some html is allowed: )  

Enter the code shown (prevents robots):