Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (MVP, Microsoft Partner)
  • When: 22 Apr 2010 3:17 AM
  • Last revision by (Microsoft Partner, Microsoft Community Contributor)
  • When: 23 Mar 2012 5:00 AM
  • Revisions: 43
  • Comments: 11
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 the Report Abuse link in the footer.
Wiki  >  TechNet Articles  >  SQL Server Versions

SQL Server Versions

SQL Server Versions

Name Version Number Release Date
SQL Server 2012  11.0.2100.60 1 April 2012
SQL Server 2008 R2
3rd May 2010
SQL Server 2008

6th Aug 2008
SQL Server 2005
Sep. 2005
SQL Server 2000 2000.8.00.2039
2000
SQL Server 7.0 OLAP Tools   1999
SQL Server 7.0
1998
SQL Server 6.5
1996
SQL Server 6.0   1995
SQL Server 4.21   1993
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 2008 R2 10.50.1600.0
10.50.2500
           


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 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:

Português

, , ,
Sort by: Published Date | Most Recent | Most Useful
Comments
Page 1 of 1 (1 items)