查询分析器中执行select @@version,得到类似如下结果:Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) 各版本对应如下: 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
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
select @@version
如果在8.00.2039以下, 说明没打补丁, 其它均为打过补丁.2.
开始--->运行----->cmd命令--------->type sqlsp.log
查看sqlsp.log文件后, 你就明白了.