SQL Server Version
By Bill Graziano
on 17 March 2002
| 13 Comments
| Tags: Administration
I'm continually trying to track down what service packs are installed on various SQL Servers I support. I can never find the right support page on Microsoft's site. So here's an article with all the SQL Server version information I can track down. If you know of any older versions or can help me fill out any missing data, please post in the comments and I'll update the article.
You can determine what version SQL Server is running by running
Select @@version
@@Version is a system level variable that holds the current version. On my computer this returns
Microsoft SQL Server 2000 - 8.00.384 (Intel X86)
May 23 2001 00:02:52
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
The main version number is 8.00.384 which corresponds to SQL Server 2000 SP1. See below for a complete list of versions. It will also tell us the version of the operating system we're running. In this case I'm running Windows 2000 (aka NT 5.0) Service Pack 2. You can find this same information in Enterprise Manager by right clicking on a server and choosing Properties. The version information is displayed in the General tab.
This information is pulled from the system extended procedure xp_msver. You can call this stored procedure like
exec master..xp_msver
and it returns
Index Name Internal_Value Character_Value
------ -------------------------------- -------------- ------------------------------
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.384
3 Language 1033 English (United States)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.0384.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © 1988-2000 Microsoft ...
11 LegalTrademarks NULL Microsoft® is a registered ...
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 25165824 NULL
15 WindowsVersion 143851525 5.0 (2195)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 255 255 (267902976)
20 Product ID NULL NULL
This is quite a bit of additional information. There really isn't anything exiciting in here that I can find but it's there if you need it.
SQL Server Versions
| @@Version |
SQL Server Version |
Released |
| 6.50.201 | SQL Server 6.5 RTM | |
| 6.50.213 | SQL Server 6.5 with Service Pack 1 | |
| 6.50.240 | SQL Server 6.5 with Service Pack 2 | |
| 6.50.258 | SQL Server 6.5 with Service Pack 3 | |
| 6.50.281 | SQL Server 6.5 with Service Pack 4 | |
| 6.50.415 | SQL Server 6.5 with Service Pack 5 | |
| 6.50.416 | SQL Server 6.5 with Service Pack 5a | |
| 7.00.623 | SQL Server 7.0 / MSDE 1.0 RTM | |
| 7.00.699 | SQL Server 7.0 SP1 | July 1999 |
| 7.00.842 | SQL Server 7.0 SP2 | March 20th, 2000 |
| 7.00.961 | SQL Server 7.0 SP3 | December 15th, 2000 |
| 7.00.1063 | SQL Server 7.0 SP4 | |
| 8.00.194 | SQL Server 2000 RTM | |
| 8.00.384 | SQL Server 2000 SP1 | |
| 8.00.534 | SQL Server 2000 SP2 | November 30th, 2001 |
| 8.00.760 | SQL Server 2000 SP3 | |
| 8.00.2039 | SQL Server 2000 SP4 | |
| 2005.90.1399 | SQL Server 2005 RTM | November 2005 |
| 2005.90.2047 | SQL Server 2005 SP1 | |
| 2005.90.3042.00 | SQL Server 2005 SP2 | February 2007 |
| 2005.90.3042.01 | SQL Server 2005 "SP2a" | 5 Mar 2007 |
| 2005.90.3054.00 | KB934458 - Fix to check database in maintenance plans. Also read Bob Ward's post on SP2 for a great description of what to install. | 5 Apr 2007 |
Analysis Services
You can determine the OLAP version by starting the OLAP Manager. Click on the Servers node in the tree view and click on About Microsoft SQL Server OLAP Services. The versions are listed below:
| Help About | SQL Server OLAP Services version |
| 7.0.1073 | SQL Server 7.0 OLAP RTM |
| 7.0.1295 | OLAP Services SP1 |
| 7.0.1458 | OLAP Services SP2 |
| 7.0.1508 | OLAP Services SP3 |
| 8.0.194 | SQL Server 2000 Analysis Services RTM |
| 8.0.382 | Analysis Services SP1 |
| 8.0.532 | Analysis Services SP2 |
