Share via


SQL Server Versions

 

Overview

 

Name Version Number Release Date Code Name
[[SQL Server 2017]] 14.0.1000.169 21 Sep 2018 Helsinki
[[articles:SQL Server 2016: What's New]] 13.00.1601.5 1 Jun 2016 2016
[[SQL Server 2014]] 12.0.2000.00 18 Mar 2014 Hekaton
[[SQL Server 2012]] 11.0.2100.60 1 April 2012 Denali
[[articles:SQL Server 2008 R2|SQL Server 2008 R2]] 10.50.1600.1 3rd May 2010 Kilimanjaro
[[SQL Server 2008]] 10.00.1600.22 6th Aug 2008 Katmai
[[articles:SQL Server 2005|SQL Server 2005]] 9.00.1399 Sep. 2005 Yukon
[[articles:SQL Server 2000|SQL Server 2000]] 8.00.2039 2000 Shiloh
[[SQL Server 7.0 OLAP Tools]] 1999 Palato mania
[[articles:SQL Server 7.0|SQL Server 7.0]] 1998 Sphinx
[[articles:SQL Server 6.5|SQL Server 6.5]] 1996 Hydra
[[SQL Server 6.0]] 1995 SQL95
[[SQL Server 4.21]] 1993 SQLNT
[[SQL Server 1.1]] 1991
[[SQL Server 1.0]] 1989

  

Service Pack editions

 

Name RTM/No SP SP1 SP2 SP3 SP4
[[articles:SQL Server 2016: What's New]] 13.00.1601.5 13.0.4001.0
[[SQL Server 2014]] 12.00.2000.8 12.00.4100.1 12.00.5000
[[SQL Server 2012]] 11.0.2100.60 11.0.3000.00 11.0.5569.0 11.0.6020
[[articles:SQL Server 2008 R2|SQL Server 2008 R2]] 10.50.1600.0 10.50.2500 10.50.4000.0 10.50.6000.34
[[SQL Server 2008]] 10.00.1600.22 10.0.2531.0 10.0.4000.0 10.00.5500 10.0.6000.29
SQL Server 2005 9.00.1399 9.00.2047 9.00.3042 9.00.4035 9.00.5000
SQL Server 2000 8.00.194 8.00.384 8.00.532 8.00.760 8.00.2039
SQL Server 7.0 7.00.623 7.00.699 7.00.842 7.00.961 7.00.10

 

References

For more complete information see

 

Querying for version/edition info

Get the current installed version of SQL Server:

SELECT @@VERSION AS Version

or nicer:

SELECT 
    SERVERPROPERTY('Edition') AS Edition,
    SERVERPROPERTY('ProductVersion') AS ProductVersion,
    SERVERPROPERTY('ProductLevel') AS ProductLevel

shows result like: "9.00.3054.00, SP2, Developer Edition."

or e.g.

or e.g. 

select @@microsoftversion / 0x01000000, @@microsoftversion & 0xFFFF

 

See Also

 

Other Languages

This article is also available in the following languages: