Posts tagged SQL Server Version

To get the SQL Server 2000 Version and Service Pack installed, from Query Analyzer run the following:

SELECT @@VERSION
GO

or alternatively, you can use:

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
GO

The returned value should be similar to this:

Microsoft SQL Server 2000 – 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

Alternatively, you can follow Microsoft’s Article ID: 321185