C++/VB - SQL Version (Build) with WMI

Asked By Mick

05-Feb-10 05:01 AM

Hello ng

How can I get the SQL-Server Version and Edition with WMI or registrykey?
This server is patched with SP3 and CU5. The BuildNumber is 10.0.2746.0 now.

This RegistryKey give only the basic insallation version, not with updates.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\BIDS\Setup]

With this SELECT I can list what I want, but I search a WMI querie.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition')
10.0.2746.0
Enterprise Edition (64-bit)

thanks for your help
Mick

05-Feb-10 01:55 PM

I would use the T-SQL @@VERSION function in a query to get the SQL Version.
I use ADO in a VBScript program to run SQL statements, but you can also use
query analyzer or isql or a similar utility. The T-SQL statement is:

SELECT @@VERSION AS Version

A VBScript solution could be:
=============
' SQLVersion.vbs
' VBScript program to query SQL Server version.

Option Explicit

Dim strConnect, adoConnection, adoRecordset, strVersion

strConnect = "DRIVER={SQL Server};" _
& "Trusted_Connection=Yes;" _
& "DATABASE=MyDatabase;" _
& "SERVER=MyServer\MyInstance"

Set adoConnection = CreateObject("ADODB.Connection")
adoConnection.ConnectionString = strConnect
adoConnection.Open

Set adoRecordset = CreateObject("ADODB.Recordset")
Set adoRecordset.ActiveConnection = adoConnection

adoRecordset.Source = "SELECT @@VERSION AS Version"

adoRecordset.Open

Do Until adoRecordset.EOF
strVersion = adoRecordset.Fields("Version").Value
Wscript.Echo strVersion
adoRecordset.MoveNext
Loop

' Clean up.
adoRecordset.Close
adoConnection.Close
========
My connection string assumes a named instance and Windows Integrated
Authentication.

--
Richard Mueller
MVP Directory Services
Hilltop Lab - http://www.rlmueller.net
--

08-Feb-10 04:08 AM

Newsbeitrag

Hello Richard

Exactly I looked for that!
Thanks a lot.

Greets from Switzerland.
Mick