How to identify SQL version & build…
Posted by bartvdw on March 30, 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
