Using WQL and Scripting Languages with the WMI Provider

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Management applications access SQL Server services and network settings using the Windows Management Instrumentation (WMI) Provider for Configuration Management objects in two ways:

  • Using a WQL editor or query tool, such as WBEMTest.exe to query the object set with the Windows Management Instrumentation Language (WQL).

  • Using a scripting language, such as VBScript.

    Alternatively, SQL Server services and network settings can be managed programmatically using the WMI managed objects in SMO. For more information about programming WMI managed objects, see Managing Services and Network Settings by Using WMI Provider.

    The WMI provider for Configuration Management can be accessed by using the SQL Server Configuration Manager and Microsoft Management Console. For more information about accessing the WMI provider from a user interface, see Managing Services How-to Topics (SQL Server Configuration Manager).

See Also

Access WMI Provider for Configuration Management using WQL
Modify SQL Server Service Advanced Properties using VBScript