Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

How can I tell if SP3 is installed for my SQL Server 2005 instance?

share|improve this question
up vote 1 down vote accepted

Here's a pretty comprehensive page on figuring out your version in a variety of ways.

share|improve this answer
the sql2005 link only goes up to sp1 beta – kenwarner Oct 4 '10 at 17:37
@qntmfred - the Microsoft KB page you reference above is also linked on the page... "See KB #321185 for official Microsoft techniques" – nedm Oct 4 '10 at 17:56
ah cool didn't see that since it was under the version 7.0 section – kenwarner Oct 4 '10 at 18:17
Fair enough, I probably would've stopped reading when I saw 7.0 too! – nedm Oct 4 '10 at 18:19

How to determine which version of SQL Server 2005 is running
To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement.

SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

The following results are returned:

  • The product version (for example, 9.00.1399.06)
  • The product level (for example, RTM)
  • The edition (for example, Enterprise Edition)

For example, the results resemble the following.

9.00.1399.06 RTM Enterprise Edition

The following table lists the Sqlservr.exe version number.

Release                Sqlservr.exe
RTM                      2005.90.1399
SQL Server 2005  Service Pack 1 2005.90.2047
SQL Server 2005  Service Pack 2 2005.90.3042
SQL Server 2005  Service Pack 3 2005.90.4035

share|improve this answer
SQL Server 2005 Service Pack 3 2005.90.4053 will be for the recommended security patch for SP3. – jl. Oct 4 '10 at 19:14

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.