SQL Server 2005: What Service Pack is Installed?

Home -> Database

2281 views

From the computer of: shamanstears (678 recipes)
Created: Jan 07, 2008     Updated: Jan 09, 2008


Add a comment

Add to:
Add to stumbleuponAdd to del.icio.usDigg itAdd to FURL

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.

Subscribe to the Tech-Recipes Newsletter

You can get tips like this delivered in your email every week!

Enter your Email

We will never, ever sell your email address or spam you.





Related recipes:

  SQL 2000 - Find version and service pack info
  SQL Server 2005: How To Enable xp_cmdshell
  SQL Server 2005: Include Column Headers When Copying Grid Query Results
  SQL Server 2005: How to Attach (or Reattach) a Database Missing the LDF
  SQL Server 2005: How To Set Up Database Mail
  SQL Server 2005: Move tempdb
  SQL Server 2005: The Copy Database Wizard
  SQL Server 2005: Return a Comma Delimited Result Set from Queries
  SQL Server 2005: How To Perform a Full Backup of a Database
  SQL Server 2005: Enforce Password Policy and Expiration

 

Sponsored links

 

Affiliated Sites


Certification Journals
Free certification exam study guides and help

Tech-Recipes Blogs
More tips and news from the tech-recipes authors

 

Login

Nickname

Password

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.