>Code this line in a stored proc (or in the Query Analyzer to test) in SQL Server 2000:
>
>SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
Jim, this gives
8.00.665 SP2 Developer Edition
on my machine. I've often just used
SELECT @@Version which gives
Microsoft SQL Server 2000 - 8.00.665 (Intel X86)
Jul 29 2002 15:02:32 Copyright (c) 1988-2000 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 1) I notice that it doesn't give the service pack level of the server. The SERVERPROPERTY function has a lot of other options, so it's worth taking a look to see what it does.
Finally, the xp_msver stored procedure (sproc) also gives a host of information. Called without arguments it gives the following on my machine:
1 ProductName NULL Microsoft SQL Server
2 ProductVersion 524288 8.00.665
3 Language 1033 English (United States)
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.0665.00
9 InternalName NULL SQLSERVR
10 LegalCopyright NULL © 1988-2001 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 43581440 NULL
15 WindowsVersion 170393861 5.1 (2600)
16 ProcessorCount 1 1
17 ProcessorActiveMask 1 00000001
18 ProcessorType 586 PROCESSOR_INTEL_PENTIUM
19 PhysicalMemory 511 511 (536305664)
20 Product ID NULL NULL
