How do I see if SQL SERVER 2000 has hit SP4 patches

How do I see if SQL SERVER 2000 has hit SP4 patches

In fact, just query the version number to know.
In Query Analyzer, enter

Select @@ version

or enter print @ @version

If it is a patch that has SP4 installed. should be the following information:

Microsoft SQL Server 2000-8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790:service Pack 1)

Other version information is as follows

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-RTM
8.00.384 SQL Server SP1
8.00.534 SQL Server SP2 November 30th, 2001
8.00.760 SQL Server SP3
8.00.2039 SQL Server SP4

This article is from the "Feng Xiaoqing blog" blog, make sure to keep this source http://fengyunshan911.blog.51cto.com/995251/1954353

How do I see if SQL SERVER 2000 has hit SP4 patches