View SQL Server 2000 version

 

View SQL Server version number (SQL Server 2000 & 2005) Time: 10:44:37 Source: Network Author: Unknown CLICK: 2354
1. View SQL Server 2005 version
Select serverproperty (& #039; productversion & #039 ;)
, Serverproperty (& #039; productlevel & #039 ;)
, Serverproperty (& #039; edition & #039 ;)

The query result of SQL Server 2005 is as follows:
1. View SQL Server 2005 version
Select serverproperty ('productversion ')
, Serverproperty ('productlevel ')
, Serverproperty ('version ')
The query result of SQL Server 2005 is as follows:

Version level Edition
-----------------------------------
9.00.3042.00 SP2 Enterprise Edition
The following table lists the SQL Server 2005 version numbers:

SQL Server 2005 version 2005 description
-----------------------------------------------------
2005.90.1399 RTM (release to manufacturing)
2005.90.2047 SQL Server 2005 SP1
2005.90.3042 SQL Server 2005 sp2
Ii. View SQL Server 2000 version
Select serverproperty ('productversion ')
, Serverproperty ('productlevel ')
, Serverproperty ('version ')
The query result of SQL Server 2000 is as follows:

Version level Edition
-----------------------------------
8.00.2039 SP4 Enterprise Edition
The following table lists the version numbers of SQL Server 2000:

SQL Server 2000 version 2000 description
-----------------------------------------------------
2000.80.194.0 RTM (release to manufacturing)
2000.80.384.0 SQL Server 2000 sp1
2000.80.534.0 SQL Server 2000 sp2
2000.80.760.0 SQL Server 2000 sp3
2000.80.760.0 SQL Server 2000 sp3a
2000.8.00.2039 SQL Server 2000 SP4
Common method for viewing SQL Server version: @ version
Select @ version
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)
Microsoft SQL Server 2005-9.00.3042.00 (Intel x86)
Feb 9 2007 22:47:07 copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (build 3790: Service Pack 2)
It can be seen that the @ version Version result also contains the OS version information. At the same time, @ version is applicable to SQL Server 6.5 and later versions.

View SQL Server 2000 version
Select serverproperty ('productversion ')
, Serverproperty ('productlevel ')
, Serverproperty ('version ')

 

The query result of SQL Server 2000 is as follows:

Version level Edition
-----------------------------------
8.00.760 SP3 Enterprise Edition