Microsoft Technologies » SQL Server
How do I determine the exact version number of the SQL Server? And what build and Service Pack does it correspond to?
To determine the version number of the SQL Server running, execute the following query:
SELECT @@VERSION
GO
The response may look similar to:
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
or
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
But what does this number convey? How to determine which SQL Server Service Pack is installed?
There is no direct way to get to know what KB-Updates or Service Packs are installed by simply executing a query. One needs to perform a look against a table. You may find exhaustive list here. However, for the sake of brevity, given a below a quick-lookup:
| Release/Service Pack | Version |
|---|---|
| SQL Server 7.0 RTM | 7.00.623 |
| SQL Server 7.0 SP1 | 7.00.699 |
| SQL Server 7.0 SP2 | 7.00.842 |
| SQL Server 7.0 SP3 | 7.00.961 |
| SQL Server 7.0 SP4 | 7.00.1063 |
| SQL Server 2000 RTM | 8.00.194 |
| SQL Server 2000 SP1 | 8.00.384 |
| SQL Server 2000 SP2 | 8.00.534 |
| SQL Server 2000 SP3 | 8.00.760 |
| SQL Server 2000 SP4 | 8.00.2039 |
| SQL Server 2005 RTM | 9.00.1399 |
| SQL Server 2005 SP1 | 9.00.2047 |
| SQL Server 2005 SP2 | 9.00.3042 |
The latest SQL Server Service Packs and updates can be found on the Microsoft website here.
Last update: 2007-07-08 14:29
Author: Edujini Labs Pvt Ltd
Revision: 1.0
Print this record
Send to a friend
Show this as PDF file
Export as XML-File
You cannot comment on this entry