SQL Server patch version check

The patch version check of SQL Server is not as direct as the windows patch version check. If a System Administrator does not know the patch number corresponding to the SQL Server version, it may also encounter some trouble, therefore, it is explained that using this method to identify machines is a safe way and will not affect the system.

1. log on to SQL Server using iSQL or SQL query analyzer. If iSQL is used, enter iSQL-U sa in the CMD window, and then enter the password; if you use the SQL query analyzer, start it from the program and enter the SA and password (you can also use Windows for verification ).

2. in iSQL, enter:

Select @ version;

Go

Or input in the SQL query analyzer (in fact, if you don't want to enter it, you just need to open the help information :))

Select @ version;

Then, press the execution button;

The SQL version information is returned as follows:

Microsoft SQL Server 2000-8.00.760 (Intel x86) Dec 17 2002 14:22:05 copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (build 2195: Service Pack 3)

8.00.760 indicates the SQL Server version and patch number. The relationship is as follows:

SQL Server 2000 version and level @ version product level

Original version 8.00.194 RTM of SQL Server 2000

Database components SP1 8.00.384 SP1

Database components SP2 8.00.534 SP2

Database components SP3, sp3a, or MSDE 2000 release a 8.00.760 SP3

Database components SP4 8.00.2039 SP4

In this way, we can see the correct version and patch number of SQL Server.

We can also use xp_msver to see more detailed information.