0

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

2 Answers 2

1

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

4
  • the sql2005 link only goes up to sp1 beta
    – kenwarner
    Oct 4, 2010 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, 2010 at 17:56
  • 1
    ah cool didn't see that since it was under the version 7.0 section
    – kenwarner
    Oct 4, 2010 at 18:17
  • Fair enough, I probably would've stopped reading when I saw 7.0 too!
    – nedm
    Oct 4, 2010 at 18:19
2

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

1
  • SQL Server 2005 Service Pack 3 2005.90.4053 will be for the recommended security patch for SP3.
    – jl.
    Oct 4, 2010 at 19:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .