Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Monday, 10 October 2016

Details of SQL Server Latest Service Pack

SQL Server Latest Service Pack summary:

RTM (no SP)SP1SP2SP3SP4
↓ SQL Server 2016
     codename ?
13.0.1601.5
↓ SQL Server 2014
     codename Hekaton SQL14
12.0.2000.812.0.4100.1
or 12.1.4100.1
12.0.5000.0
or 12.2.5000.0
↓ SQL Server 2012
     codename Denali
11.0.2100.6011.0.3000.0
or 11.1.3000.0
11.0.5058.0
or 11.2.5058.0
11.0.6020.0
or 11.3.6020.0
↓ SQL Server 2008 R2
     codename Kilimanjaro
10.50.1600.110.50.2500.0
or 10.51.2500.0
10.50.4000.0
or 10.52.4000.0
10.50.6000.34
or 10.53.6000.34
↓ SQL Server 2008
     codename Katmai
10.0.1600.2210.0.2531.0
or 10.1.2531.0
10.0.4000.0
or 10.2.4000.0
10.0.5500.0
or 10.3.5500.0
10.0.6000.29
or 10.4.6000.29
↓ SQL Server 2005
     codename Yukon
9.0.1399.069.0.20479.0.30429.0.40359.0.5000
↓ SQL Server 2000
     codename Shiloh
8.0.1948.0.3848.0.5328.0.7608.0.2039
↓ SQL Server 7.0
     codename Sphinx
7.0.6237.0.6997.0.8427.0.9617.0.1063

Table 1: Latest updates available for each SQL Server version

VersionMost recent service packLatest cumulative updateComplete version information
SQL Server 2016NoneCU2 for 2016 RTM (13.0.2164.0 – September 2016)SQL Server 2016 builds
SQL Server 2014SQL Server 2014 SP2 (12.0.5000.0 – July 2016)CU1 for 2014 SP2 (12.0.5511.0 – August 2016)
CU8 for 2014 SP1 (12.0.4468.0 – August 2016)
SQL Server 2014 builds
SQL Server 2012SQL Server 2012 SP3 (11.0.6020.0 – November 2015)CU5 for 2012 SP3 (11.0.6544.0 – September 2016)

CU14 for 2012 SP2 (11.0.5657.0 –September 2016)

CU16 for 2012 SP1 (11.0.3487.0 - May 2015)
SQL Server 2012 builds
SQL Server 2008 R2SQL Server 2008 R2 SP3(10.50.6000.34 – September 2014)

Note Latest and final release for this version
NoneSQL Server 2008 R2 builds
SQL Server 2008SQL Server 2008 SP4 (10.0.6000.29 – September 2014)

Note Latest and final release for this version
NoneSQL Server 2008 builds
SQL Server 2005SQL Server 2005 SP4 (9.00.5000.00 – December 2010)NoneSQL Server 2005 builds
Note "Latest" = During the past 12 months. 

Ref:
https://support.microsoft.com/en-in/kb/321185
http://sqlserverbuilds.blogspot.in/