Can I still use WMI to manage SQL Server 2005 and 2008?

I've seen some write-ups on just how to make use of WMI to manage SQL2000 web servers (after mounting SQLWMI80.msi by hand) yet I've not seen anything concerning this for SQL2005 and also SQL2008.

Has this been decreased? Or is WMI currently mounted as typical with 2005 and also 2008?

2022-06-07 14:34:38
Source Share
Answers: 2

The recommended method is to make use of SMO

2022-06-07 14:55:22

Yes see SQL Server 2008 Books Online (June 2009)WMI Provider for Configuration Management Concepts this additionally gives the web links to the 2005 variation. Yet you'll intend to make use of SMO rather. 2008 additionally has a powershell carrier.

2022-06-07 14:54:12