Step 1: query using SQL statements
Select @ version
The query result is as follows:
Microsoft SQL Server 2000-8.00.2039 (Intel x86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Personal Edition on Windows NT 5.1 (build 2600: Service Pack 2)
8.00.2039 indicates the version of the installed SQL Server. Find the patch version corresponding to the following table. 8.00.2039 indicates that SP4 is installed, and 8.00.760 indicates that SP3.
Step 2: Search for the specific patch version against the table
SQL Server versions
@ Version SQL Server version released
6.50.201 SQL Server 6.5 RTM
6.50.213 SQL Server 6.5 with Service Pack 1
6.50.240 SQL Server 6.5 with Service Pack 2
6.50.258 SQL Server 6.5 with Service Pack 3
6.50.281 SQL Server 6.5 with Service Pack 4
6.50.415 SQL Server 6.5 with Service Pack 5
6.50.416 SQL Server 6.5 with Service Pack 5A
7.00.623 SQL Server 7.0/MSDE 1.0 RTM
7.00.699 SQL Server 7.0 SP1 July 1999
7.00.842 SQL Server 7.0 SP2 March 20th, 2000
7.00.961 SQL Server 7.0 SP3 December 15th, 2000
7.00.1063 SQL Server 7.0 SP4
8.00.194 SQL Server 2000 RTM
8.00.384 SQL Server 2000 sp1
8.00.534 SQL Server 2000 sp2 November 30th, 2001
8.00.760 SQL Server 2000 sp3
8.00.2039 SQL Server 2000 SP4
The relationship is as follows:
8.00.194 ------- SQL Server 2000 RTM
8.00.384 ------- (SP1)
8.00.534 ------- (SP2)
8.00.760 ------- (SP3)
8.00.2039 ------- (SP4)