3

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?

Guy
  • 2,668
  • 2
  • 20
  • 24

2 Answers2

2

The preferred method is to use SMO

Nick Kavadias
  • 10,796
  • 7
  • 37
  • 47
2

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.

Jim B
  • 24,081
  • 4
  • 36
  • 60
  • 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