Bart's Weblog

Just a blog…

How to identify Microsoft SQL Server version & build…

Posted by bartvdw on 3030/0303/2008

Some time ago I needed to easily find the SQL version & build installed on a machine to identify missing patches. Below the links that will tell you everything you need about this!

Microsoft SQL Server 2008, 2005, 2000 and 7.0 Builds
http://sqlserverbuilds.blogspot.com/

How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/

Also some registry keys that could be easy when you write custom scripts.

SQL Server 2005 Express
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\SQLEXPRESS\MSSQLServer\CurrentVersion — CurrentVersion — REG_SZ

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: