Home / server / Questions / 187422
Accepted
kenwarner
Asked: 2010-10-05 09:24:58 +0800 CST

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

  • 772

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

sql-server sql-server-2005 service-pack

2 Answers

  1. 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

    • 2
  2. Best Answer
    • 1