How to check whether SQL2000 SP4 is successfully installed and SP4 patch is installed

1. Run the following statement in the query Analyzer:
Select serverproperty ('productversion ')
, Serverproperty ('productlevel ')
, Serverproperty ('version ')
For example, 8.00.2039 sp4standard edition indicates that SP4 has been installed.

2. In the Enterprise Manager, open the console root directory, Microsoft SQL servers, SQL Server group, right-click (XXX) (WindowsNT), and view the product version behavior 8.00.2039 (SP4) in the properties)

 

 

3. The following table lists the version numbers of sqlservr.exe: the release version of 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

4. Download The SQL2000 SP4 patch from the relevant website.

Http://www.microsoft.com/downloads/details.aspx? Familyid = 8e2dfc8d-c20e-4446-99a9-b7f0109f8bc5 & displaylang = ZH-CN # filelist

SQL2000.AS-KB884525-SP4 x86-CHS.EXE
SQL2000.MSDE-KB884525-SP4 x86-CHS.EXE
SQL2000-KB884525-SP4-x86-CHS.EXE

5. Run the. exe file on it, and then there is a setup. BAT file in the folder to run the installation.
6. Run the 2nd statement in the query analyzer to check whether the version number is SP4.