Microsoft support has a
web page for this.
In short,
1. run 'select @@version'.
| Version Number | Service Pack |
|---|
| 6.50.479 | SQL Server 6.5 Service Pack 5a (SP5a) Update |
| 6.50.416 | SQL Server 6.5 Service Pack 5a (SP5a) |
| 6.50.415 | SQL Server 6.5 Service Pack 5 (SP5) |
| 6.50.281 | SQL Server 6.5 Service Pack 4 (SP4) |
| 6.50.258 | SQL Server 6.5 Service Pack 3 (SP3) |
| 6.50.240 | SQL Server 6.5 Service Pack 2 (SP2) |
| 6.50.213 | SQL Server 6.5 Service Pack 1 (SP1) |
| 6.50.201 | SQL Server 6.5 RTM |
| Version Number | Service Pack |
|---|
| 7.00.1063 | SQL Server 7.0 Service Pack 4 (SP4) |
| 7.00.961 | SQL Server 7.0 Service Pack 3 (SP3) |
| 7.00.842 | SQL Server 7.0 Service Pack 2 (SP2) |
| 7.00.699 | SQL Server 7.0 Service Pack 1 (SP1) |
| 7.00.623 | SQL Server 7.0 RTM (Release To Manufacturing) |
if the version number string is started with "8.", "9." or later, then run
"SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')"
The following results are returned:
- The product version (for example, 8.00.534)
- The product level (for example, "RTM" or "SP2")
- The edition (for example, "Standard Edition"). For example, the results resemble the following:
8.00.534 SP2 Standard Edition
| Release | Sqlservr.exe |
|---|
| RTM | 2000.80.194.0 |
| SQL Server 2000 SP1 | 2000.80.384.0 |
| SQL Server 2000 SP2 | 2000.80.534.0 |
| SQL Server 2000 SP3 | 2000.80.760.0 |
| SQL Server 2000 SP3a | 2000.80.760.0 |
| SQL Server 2000 SP4 | 2000.8.00.2039 |
| 9.00.1399.06 | RTM | Enterprise Edition |
The following table lists the Sqlservr.exe version number.
| Release | Sqlservr.exe |
| RTM | 2005.90.1399 |
| SQL Server 2005 Service Pack 1 | 2005.90.2047 |
| SQL Server 2005 Service Pack 2 | 2005.90.3042 |
| SQL Server 2005 Service Pack 3 | 2005.90.4035 |
| 10.0.1600.22 | RTM | Enterprise Edition |
The following table lists the Sqlservr.exe version number.
Collapse this tableExpand this table
| Release | Sqlservr.exe |
| RTM | 2007.100.1600.0 |
| SQL Server 2008 Service Pack 1 | 2007.100.2531.0 |
