SQL 2000 - Find version and service pack info
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')
Also see ...