Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (dMVP, Microsoft Partne)
  • When: 22 Apr 2010 3:17 AM
  • Last revision by (eMicrosoft Partne)
  • When: 4 Sep 2013 3:32 PM
  • Revisions: 63
  • Comments: 20
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SQL Server Versions

SQL Server Versions

SQL Server Versions

Name Version Number Release Date  Code Name
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  

Overview SQL Server version numbers of editions with Service Pack:

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

SQL Server 2008 10.00.1600.22 10.0.2531.0 10.0.4000.0
10.00.5500
           
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

 See also more complete information at http://sqlserverbuilds.blogspot.com/ or SQL Server versions or 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: http://support.microsoft.com/kb/321185/en-us

 

See Also

Other Languages

This article is also available in the following languages:

See Also

, , , , , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 1 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 14 Nov 2011 12:39 PM

    Ed Price - MSFT edited Revision 28. Comment: Table formatting

  • 14 Nov 2011 12:39 PM

    Ed Price - MSFT edited Revision 29. Comment: Table issues

  • 14 Nov 2011 12:38 PM

    Ed Price - MSFT edited Revision 27. Comment: Updated a link

  • 4 Oct 2010 11:55 AM

    Ed Price MSFT edited Revision 17. Comment: Added a "See Also" link.

  • 27 May 2010 12:34 PM

    Ed Price MSFT edited Revision 15. Comment: Added "See Also" section.

  • 18 May 2010 12:21 PM

    Ed Price MSFT edited Revision 14. Comment: Minor edit.

  • 18 May 2010 12:20 PM

    Ed Price MSFT edited Revision 13. Comment: Title caps issue.

  • 17 May 2010 5:55 PM

    Ed Price MSFT edited Revision 12. Comment: Removed links to contentless stubs.

  • 22 Apr 2010 6:54 AM

    jamiet edited Revision 4. Comment: increased borders on table

  • 22 Apr 2010 6:35 AM

    Toni edited Revision 3. Comment: added some infos, to be completed...

Page 1 of 1 (10 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 22 Apr 2010 6:35 AM

    Toni edited Revision 3. Comment: added some infos, to be completed...

  • Posted by
    on 22 Apr 2010 6:54 AM

    jamiet edited Revision 4. Comment: increased borders on table

  • Posted by
    on 17 May 2010 5:55 PM

    Ed Price MSFT edited Revision 12. Comment: Removed links to contentless stubs.

  • Posted by
    on 18 May 2010 12:20 PM

    Ed Price MSFT edited Revision 13. Comment: Title caps issue.

  • Posted by
    on 18 May 2010 12:21 PM

    Ed Price MSFT edited Revision 14. Comment: Minor edit.

  • Posted by
    on 27 May 2010 12:34 PM

    Ed Price MSFT edited Revision 15. Comment: Added "See Also" section.

  • Posted by
    on 4 Oct 2010 11:55 AM

    Ed Price MSFT edited Revision 17. Comment: Added a "See Also" link.

  • Posted by
    on 14 Nov 2011 12:38 PM

    Ed Price - MSFT edited Revision 27. Comment: Updated a link

  • Posted by
    on 14 Nov 2011 12:39 PM

    Ed Price - MSFT edited Revision 28. Comment: Table formatting

  • Posted by
    on 14 Nov 2011 12:39 PM

    Ed Price - MSFT edited Revision 29. Comment: Table issues

  • Posted by
    on 23 Mar 2012 5:04 AM

    adicionado link ao Guia de Sobrevivencia do SQL Server

  • Posted by
    on 25 Aug 2012 3:23 AM

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

  • Posted by
    on 18 Oct 2012 2:00 AM

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

  • Posted by
    on 18 Oct 2012 2:10 AM

    ganeshkuppuswamy edited Revision 54. Comment: Altered code name

  • Posted by
    on 14 Jan 2013 3:43 PM

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

Page 1 of 2 (20 items) 12