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
- http://sqlserverbuilds.blogspot.com/
- How to determine the version, edition and update level of SQL Server and its components
- SQL Server versions
- http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx
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
- List of Technologies and Related Topics
- SQL Server Overview
- [[Microsoft SQL Server 2008 SP2 Release Notes]]
- SQL Server Query Language - Transact-SQL
Other Languages
This article is also available in the following languages: