Q

Function to determine which Service Pack is installed

SQL Server expert Adam Machanic offers a function to determine which service pack you currently have installed.

How can I tell which current Service Pack is installed in my SQL Server 2005 instance?
You can find the current service pack using the 'ProductLevel' option of the SERVERPROPERTY function. Use the following T-SQL:

SELECT SERVERPROPERTY('ProductLevel')

If the returned value is 'RTM', your server has no service packs applied. SPn means that you have service pack n applied.

This was first published in January 2006

Dig deeper on SQL Server Migration Strategies and Planning

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close