sql server 2000 版本信息查詢
廣告：
use master
(1)
exec xp_msver
Index Name Internal_Value Character_Value
---------------------------------------------------------
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.2039
3 Language 2052 中文(中國)
4 Platform NULL NT INTEL X86
5 Comments NULL NT INTEL X86
6 CompanyName NULL Microsoft Corporation
7 FileDescription NULL SQL Server Windows NT
8 FileVersion NULL 2000.080.2039.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL ? 1988-2004 Microsoft Corp. All rights reserved.
11 LegalTrademarks NULL Microsoft? is a registered trademark of Microsoft Corporation. Windows(TM) is a trademark of Microsoft Corporation
12 OriginalFilename NULL SQLSERVR.EXE
13 PrivateBuild NULL NULL
14 SpecialBuild 133627904 NULL
15 WindowsVersion 248381957 5.2 (3790)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 511 511 (536301568)
20 Product ID NULL NULL
(2)
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)
SQL Server的版本和補丁號對應關系如下：
8.00.194 －——————SQL Server 2000 RTM
8.00.384 －——————(SP1)
8.00.534 －——————(SP2)
8.00.760 －——————(SP3)
(3)
select 版本=serverproperty('productversion'),產品級別=serverproperty('productlevel'),版本=serverproperty('edition')
-------------------------------------------
版本 產品級別 版本
8.00.2039 SP4 Enterprise Edition
select serverproperty('productlevel')
廣告：
