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

Question

score 2 · Answer 1 · answered Oct 04 '10 at 17:42

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

SQL Server 2005 Service Pack 3 2005.90.4053 will be for the recommended security patch for SP3. — jl., Oct 04 '10 at 19:14

score 1 · Accepted Answer · answered Oct 04 '10 at 17:28

1

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

answered Oct 04 '10 at 17:28

nedm

5,630
5
32
52

the sql2005 link only goes up to sp1 beta – kenwarner Oct 04 '10 at 17:37
@qntmfred - the Microsoft KB page you reference above is also linked on the page... "See [KB #321185](http://support.microsoft.com/default.aspx/kb/321185) for official Microsoft techniques" – nedm Oct 04 '10 at 17:56
1

ah cool didn't see that since it was under the version 7.0 section – kenwarner Oct 04 '10 at 18:17
Fair enough, I probably would've stopped reading when I saw 7.0 too! – nedm Oct 04 '10 at 18:19

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

2 Answers2