Determining SQL Server 2000 version - friendly reminder

I’m doing maintenance on my servers this evening and one of the items on the list is to apply SQL Server 2000 SP4; however, I want to verify the version of the server first. I thought I would blog about how to do this as a quick refresher (and maybe something new for some folks).

To query the server version I simply execute the query: SELECT @@VERSION  

The result that I received was:
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.2 (Build 3790: Service Pack 1)

So, the above string means my SQL Server 2000 SP3 instance is running on Windows Server 2003 SP1.  Spiffy. 

Here’s a handy chart for you (courtesy of the SP4 readme):

You are also able obtain other properties via the following query:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

Which gave me:
8.00.2039  SP4  Enterprise Edition 

-Nino