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)	SP1	SP2	SP3	SP4
SQL Server 2012      codename Denali	-
SQL Server 2008 R2      codename Kilimanjaro	10.50.1600.1	10.50.2500
SQL Server 2008      codename Katmai	10.00.1600.22	10.00.2531	10.00.4000	10.00.5500
SQL Server 2005      codename Yukon	9.00.1399.06	9.00.2047	9.00.3042	9.00.4035	9.00.5000
SQL Server 2000      codename Shiloh	8.00.194	8.00.384	8.00.532	8.00.760	8.00.2039
SQL Server 7.0      codename Sphinx	7.00.623	7.00.699	7.00.842	7.00.961	7.00.106

referenced from sqlserverbuilds.blogspot.com