Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Server version location

Author  Topic 

gam
Starting Member

9 Posts

Posted - 2009-02-10 : 11:16:48
If I run
select SERVERPROPERTY('ProductVersion')
I get
8.00.2050

Is this info stored anywhere in the registry?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE\MSSQLServer\CurrentVersion\CurrentVersion has 8.00.194

and

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE\MSSQLServer\CurrentVersion\CSDVersion has
8.00.2039

and

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\INSTANCE\Setup\Patchlevel has
8.4.2039

I'd like to be able to collect this using an existing vbscript script that gathers other server info through the registry.
   

- Advertisement -