Versions and Service Packs of SQL Server (2012, 2008 R2, 2008, 2005)

Have you installed all service packs and necessary patches for all your SQL Server instances? Check the version with this table, if not, get them downloaded and installed.

SQL Server	Code Name	Initial Version	Service Packs
2014	Hekaton	12.00.2000.8	CU1: 12.0.2342.0 CU3: 12.0.2402
2012	Denali	11.00.2100	SP1: 11.00.3000 SP1: CU#7: 11.0.3393 SP1: CU#8: 11.0.3401 SP1: CU#9: 11.0.3412 SP2: 11.0.5058 SP2: HotFix – 11.0.5522 SP2: CU#1: 11.0.5532
2008 R2	Kilimanjaro	10.50.1600.1	SP1: 10.50.2500 SP2: 10.50.4000 SP2: CU#11: 10.50.4302 SP2: CU#12: 10.50.4305
2008	Katmai	10.00.1600.22	SP1: 10.00.2531 SP2: 10.00.4000 SP3: 10.00.5500 SP3: CU#14: 10.00.5848
2005	Yukon	9.00.1399.06	SP1: 9.00.2047 SP2: 9.00.3042 SP3: 9.00.4035 SP4: 9.00.5000 SP4: CU#3: 9.00.5266

Here are couple of ways of determining the version of your SQL Server instance;

1. SQL Server Management Studio: Object Explorer

2. @@VERSION global variable

3. SERVERPROPERTY function