Found a need to determine the Microsoft SQL Server 2005 version I was running. On a rare occasion, I need to determine the SQL Server versions being used with our Corporate Applications. Most of those installations are SQL Server 2000 with various Service Pack or Hot Fix levels.
Microsoft Support provides a document called “How to identify your SQL Server version and edition” to help you decipher the SQL Server version and edition you have installed.
SQL Server 2005
|
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 2000
|
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 |
Update (12-Jul-2007)
Some information on this blog for those who may not have moved to SQL Server 2000 Service Pack 4. It appears support for Service Pack 3a expired on July 10, 2007.
Posted by mrothouse 