What version of SQL Server do I have?

17/01/2015 13:46

This unofficial build chart lists all of the known Service Packs (SP), Cumulative Updates (CU), patches, hotfixes and other builds of MS SQL Server 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released.

Useful articles:









 
 

Quick summary:


 RTM (Gold, no SP)SP1SP2SP3SP4
↓ SQL Server 2014
     codename Hekaton SQL14
12.0.2000.8 12.00.2000.8    
↓ SQL Server 2012
     codename Denali
11.0.2100.60 11.00.2100.6011.0.3000.0
or 11.1.3000.0
11.0.5058.0
or 11.2.5058.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.22 10.00.1600.2210.0.2531.0 10.00.2531.0
or 10.1.2531.0
10.0.4000.0 10.00.4000.0
or 10.2.4000.0
10.0.5500.0 10.00.5500.0
or 10.3.5500.0
10.0.6000.29 10.00.6000.29
or 10.4.6000.29
↓ SQL Server 2005
     codename Yukon
9.0.1399.06 9.00.1399.069.0.2047 9.00.20479.0.3042 9.00.30429.0.4035 9.00.40359.0.5000 9.00.5000
↓ SQL Server 2000
     codename Shiloh
8.0.194 8.00.1948.0.384 8.00.3848.0.532 8.00.5328.0.760 8.00.7608.0.2039 8.00.2039
↓ SQL Server 7.0
     codename Sphinx
7.0.623 7.00.6237.0.699 7.00.6997.0.842 7.00.8427.0.961 7.00.9617.0.1063 7.00.1063


All SQLServer service packs are cumulative, meaning that each new service pack contains all the fixes that are included with previous service packs and any new fixes.


TSQL Script:

SELECT
@@SERVERNAME AS ServerName,
CASE
 WHEN LEFT(CAST(serverproperty('productversion') as char), 1) = 8 THEN '2000'
 WHEN LEFT(CAST(serverproperty('productversion') as char), 1) = 9 THEN '2005'
 WHEN LEFT(CAST(serverproperty('productversion') as char), 2) = 10 THEN '2008'
 WHEN LEFT(CAST(serverproperty('productversion') as char), 2) = 11 THEN '2012'
 WHEN LEFT(CAST(serverproperty('productversion') as char), 2) = 12 THEN '2014'
END AS MajorVersion,
SERVERPROPERTY ('productlevel') AS MinorVersion,
SERVERPROPERTY('productversion') AS FullVersion,
SERVERPROPERTY ('edition') AS Edition


Legend:

CTPCommunity Technology Preview (beta release)
RCRelease Candidate
RTMReleased To Manufacturing; It is the original, released build version of the product, i.e. what you get on the DVD or when you download the ISO file from MSDN.
CUCumulative Update; Cumulative updates contain the bug fixes and enhancements-up to that point in time-that have been added since the previous Service Pack release and will be contained in the next service pack release. Installation of the Cumulative Update is similar to the installation of a Service Pack. Cumulative Updates are not fully regression tested.
SPService Pack; much larger collection of hotfixes that have been fully regression tested. In some cases delivers product enhancements.
GDRGeneral Distribution Release; GDR fixes should not contain any of the CU updates.
QFEQuick Fix Engineering; QFE updates include CU fixes.


Crie um site com

  • Totalmente GRÁTIS
  • Centenas de templates
  • Todo em português

Este site foi criado com Webnode. Crie um grátis para você também!