Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've seen some articles on how to use WMI to manage SQL2000 servers (after installing SQLWMI80.msi manually) but I've not seen anything about this for SQL2005 and SQL2008.

Has this been depreciated? Or is WMI now installed as standard with 2005 and 2008?

share|improve this question

2 Answers 2

up vote 2 down vote accepted

Yes see SQL Server 2008 Books Online (June 2009)WMI Provider for Configuration Management Concepts this also provides the links to the 2005 version. But you'll want to use SMO instead. 2008 also has a powershell provider.

share|improve this answer
1  
Ho Ho! Another way to do the same thing invented by MS. Looking at SMO and seeing if it can be incorporated into my "monitoring" architecture, that mostly uses WMI. –  Guy Jul 16 '09 at 12:15

The preferred method is to use SMO

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.