HomeDatabaseSQL Server 2005: What Service Pack is Installed?

SQL Server 2005: What Service Pack is Installed?

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.

Rob Rogers
Rob Rogers
Once a prolific author here on Tech-Recipes, Rob has moved on to greener pastures.
RELATED ARTICLES

3 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android