How to determine which version of SQL Server 2000 is running
Jason's WMI SQL Related Blog
·
2005-11-30
·
via 博客园 - Jason's WMI SQL Related Blog
| How to determine which version of SQL Server 2000 is running |
|
|
http://support.microsoft.com/default.aspx?scid=kb;en-us;321185
How to determine which version of SQL Server 2000 is running
To determine which version of SQL Server 2000 is running, connect to SQL Server 2000 by using Query Analyzer, and then run the following code: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
| • |
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 result looks similar to: 8.00.534 RTM Standard Edition |
The following table lists the Sqlservr.exe version number:
| 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 | |
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。
