Overview SQL Server version numbers of editions with Service Pack:
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
Get the current installed version of SQL Server:
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
This article is also available in the following languages:
Ed Price - MSFT edited Revision 28. Comment: Table formatting
Ed Price - MSFT edited Revision 29. Comment: Table issues
Ed Price - MSFT edited Revision 27. Comment: Updated a link
Ed Price MSFT edited Revision 17. Comment: Added a "See Also" link.
Ed Price MSFT edited Revision 15. Comment: Added "See Also" section.
Ed Price MSFT edited Revision 14. Comment: Minor edit.
Ed Price MSFT edited Revision 13. Comment: Title caps issue.
Ed Price MSFT edited Revision 12. Comment: Removed links to contentless stubs.
jamiet edited Revision 4. Comment: increased borders on table
Toni edited Revision 3. Comment: added some infos, to be completed...
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.