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
 SQL Server 2008
     codename Katmai
 SQL Server 2005
     codename Yukon
 SQL Server 2000
     codename Shiloh
 SQL Server 7.0
     codename Sphinx

referenced from

No comments: