What version of SQL Server do I have?
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:
- How to identify your SQL Server version and edition
https://support.microsoft.com/kb/321185/en-us
- SQL Server Internal Database Versions
https://sqlserverbuilds.blogspot.co.nz/2014/01/sql-server-internal-database-versions.html
- Microsoft SQL Server Support Lifecycle
https://support.microsoft.com/lifecycle?LN=en-us&c2=1044
- Microsoft SQL Server Home
https://www.microsoft.com/en-us/server-cloud/products/sql-server/
- Microsoft SQL Server Developer Center
https://msdn.microsoft.com/en-nz/sqlserver
- Microsoft TechNet: Microsoft SQL Server
https://technet.microsoft.com/en-us/sqlserver
- Microsoft Knowledge Base
https://kbupdate.info/
- Sqlservr.exe versions
https://www.mskbfiles.com/sqlservr.exe.php
Quick summary:
| RTM (Gold, no SP) | SP1 | SP2 | SP3 | SP4 | |
|---|---|---|---|---|---|
 SQL Server 2014codename | 12.0.2000.8 12.00.2000.8 | ||||
| SQL Server 2012 codename Denali | 11.0.2100.60 11.00.2100.60 | 11.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.1 | 10.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.22 | 10.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.06 | 9.0.2047 9.00.2047 | 9.0.3042 9.00.3042 | 9.0.4035 9.00.4035 | 9.0.5000 9.00.5000 |
| SQL Server 2000 codename Shiloh | 8.0.194 8.00.194 | 8.0.384 8.00.384 | 8.0.532 8.00.532 | 8.0.760 8.00.760 | 8.0.2039 8.00.2039 |
| SQL Server 7.0 codename Sphinx | 7.0.623 7.00.623 | 7.0.699 7.00.699 | 7.0.842 7.00.842 | 7.0.961 7.00.961 | 7.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:
| CTP | Community Technology Preview (beta release) |
| RC | Release Candidate |
| RTM | Released 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. |
| CU | Cumulative 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. |
| SP | Service Pack; much larger collection of hotfixes that have been fully regression tested. In some cases delivers product enhancements. |
| GDR | General Distribution Release; GDR fixes should not contain any of the CU updates. |
| QFE | Quick Fix Engineering; QFE updates include CU fixes. |