Function to determine which Service Pack is installed

How can I tell which current Service Pack is installed in my SQL Server 2005 instance?

    Requires Free Membership to View

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

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.