How to: Modify SQL Server Service Advanced Properties using VBScript

  • Article

This section describes how to create a VBScript program that lists the version of installed instances of Microsoft SQL Server that are running on a computer.

The code example lists the instances of SQL Server running on the computer and its version.

Listing name and version of installed instances of SQL Server

  1. Open a new document in a text editor, such as Microsoft Notepad. Copy the code that follows this procedure and save the file with a .vbs extension. This example is called test.vbs.

  2. Connect to an instance of the WMI Provider for Computer Management with the VBScript GetObject function. This example connects to a remote computer named mpc, but omit the computer name to connect to the local computer: winmgmts:root\Microsoft\SqlServer\ComputerManagement. For more information about the GetObject function, see the VBScript reference.

  3. Use the InstancesOf method to enumerate a list of the services. The services can also be enumerated by using a simple WQL query and an ExecQuery method instead of the InstancesOf method.

  4. Use the ExecQuery method and a WQL query to retrieve the name and version of the installed instances of SQL Server.

  5. Save the file.

  6. Run the script by typing cscript test.vbs at the command prompt.

Example

set wmi = GetObject("WINMGMTS:\\.\root\Microsoft\SqlServer\ComputerManagement")
for each prop in wmi.ExecQuery("select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'VERSION'")
WScript.Echo prop.ServiceName & " " & prop.PropertyName & ": " & prop.PropertyStrValue
next