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')

courtesy http://www.tech-recipes.com/rx/2344/sql_2000_find_version_and_service_pack_info/