Using WQL and Scripting Languages with the WMI Provider for Configuration Management
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 SQL Server 구성 관리자를 사용하여 서비스 관리.
참고 항목
작업
How to: Access WMI Provider for Configuration Management using WQL
How to: Modify SQL Server Service Advanced Properties using VBScript