สำหรับ SQL 2000 เปิด Query Analyzer แล้วใช้คำสั่ง
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
หรือ
Select @@version
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 |
http://sqlserverbuilds.blogspot.com/
http://www.sqlteam.com/article/sql-server-versions
No comments:
Post a Comment