Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question

2 Answers 2

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 –  qntmfred 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
1  
ah cool didn't see that since it was under the version 7.0 section –  qntmfred 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

http://support.microsoft.com/kb/321185

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

 
discard

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.