SQL 2000 – Find version and service pack info
Contributed by katy8439 
Tagged: Database Run the following code in SQL Server 2000 Query Analyzer to return the Version and Service pack – useful if you’re having problems on a server and don’t know if you’re running the latest patches or not.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY
('productlevel'), SERVERPROPERTY ('edition')
You may also like -
SQL Server 2005: What Service Pack is Installed?
SQL Server 2000 - Find Database Language
Microsoft SQL Server: Determine MDAC Version
SQL Server 2008/2008 R2: Move tempdb to Improve Performance
SQL Server 2005: Move tempdb
Microsoft SQL Server: Determining CD Key
SQL Server 2005: How To Enable xp_cmdshell
SQL Server 2005: How to Reset a Forgotten Password for the sa Account