SQL Server Versions

SQL Server Versions

 


Overview

 

Name Version Number Release Date Code Name
SQL Server 2014 12.0.2000.00 18 Mar 2014 Hekaton
SQL Server 2012 SP1 11.0.3128.00 28 Dec 2012 Denali
SQL Server 2012 11.0.2100.60 1 April 2012 Denali
SQL Server 2008 R2 10.50.1600.1 3rd May 2010 Kilimanjaro
SQL Server 2008 10.00.1600.22 6th Aug 2008 Katmai
SQL Server 2005 9.00.1399 Sep. 2005 Yukon
SQL Server 2000 8.00.2039 2000 Shiloh
SQL Server 7.0 OLAP Tools 1999 Palato mania
SQL Server 7.0 1998 Sphinx
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
SQL Server 2012 11.0.2100.60 11.0.3000.00
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:

 


Sort by: Published Date | Most Recent | Most Useful
Comments
  • adicionado link ao Guia de Sobrevivencia do SQL Server

  • Prashant Jha edited Revision 45. Comment: Added version no. for SQL 2005, 2008 and 2008 R2

  • ganeshkuppuswamy edited Revision 53. Comment: Code name missed for SQL Versions

  • ganeshkuppuswamy edited Revision 54. Comment: Altered code name

  • Savannah Phillips edited Revision 59. Comment: added link to the most complete list of SQL releases I've found so far.

  • perfecto muy util

  • Thank you for this summary. I was wondering, which version of sql is best to use and easiest to deploy?

  • Thank you for this summary. I was wondering, which version of sql is best to use and easiest to deploy?

  • Thank you for this summary. I was wondering, which version of sql is best to use and easiest to deploy?

  • yottun8 edited Revision 60. Comment: Added Japanese version.

Page 1 of 2 (13 items) 12