SQL Server 2005: What Service Pack is Installed?

Contributor Icon Contributed by Rob Rogers  
Tag Icon Tagged: Database  

If you’re running SQL Server, it’s very wise to make sure that you have the latest service pack installed for optimum performance. If you’re not sure what service pack you have installed (or if you’re still running RTM), follow these steps to find out:


1. Open SQL Server Management Studio.

2. Click the New Query button.

3. Copy and paste the following into your query window:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
4. Click the Execute button.

The results will display the version number, service pack number and the edition of SQL Server 2005 that is installed on the server.

 

3 Comments -


  1. Regularuser said on July 20, 2010

    Thank you so much.

  2. Ittlu_anudeep said on August 15, 2010

    in seconds column i found RTM means what , i ddnt instaled any sp r waht

  3. Himanshu153 said on November 23, 2010

    love u boss!!!!!!!!!!!!!!

 

RSS feed for comments on this post. TrackBack URL

Leave a comment -