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 |
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 comment:
Incredible post! This is really nice
table presentation on different Versions and service packs of SQL.
I appreciated your way of presenting about SQL. Thanks for posting.Keep it.up....If you want to know SQL Service 2012, Then you can follow this: http://goo.gl/bI86US
Post a Comment