November 09, 2011

How to know Which Sql server version / service pack installed

Sql server has some cryptic nos to know the what version of sql server and what service pack is actually installed on your machine.

To to Sql server management studio on the machine where sql server is installed
click help/about. and match the version from below list.

or Run ...> regedit....> HKLM -> software-> microsoft.>.mssqlserver..>. currentversion

RTM (Gold, no SP)SP1SP2SP3SP4
 SQL Server 2012
     codename Denali
-
 SQL Server 2008 R2
     codename Kilimanjaro
10.50.1600.110.50.2500
 SQL Server 2008
     codename Katmai
10.00.1600.2210.00.253110.00.400010.00.5500
 SQL Server 2005
     codename Yukon
9.00.1399.069.00.20479.00.30429.00.40359.00.5000
 SQL Server 2000
     codename Shiloh
8.00.1948.00.3848.00.5328.00.7608.00.2039
 SQL Server 7.0
     codename Sphinx
7.00.6237.00.6997.00.8427.00.9617.00.106


referenced from sqlserverbuilds.blogspot.com

No comments: