Check the SQL Server 2000 version and patch version.

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.