SQL 2000 – Find version and service pack info

Posted May 8, 2007 by katy8439 in 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')

The Conversation

Follow the reactions below and share your own thoughts.