SQL 2000 - Find version and service pack info

Contributor Icon Contributed by katy8439 Date Icon May 8, 2007  
Tag Icon 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')

Previous recipe | Next recipe |
 

 
close Reblog this comment
Powered by Disqus · Learn more
blog comments powered by Disqus