Skip to content

How to determine which service pack of sql server is installed

To get to know what service pack is installed on a sql server instance you can obtain the current version of SQL Server and then look up to which service pack it correspond or you may use query against SQL Server instances starting from sql server 2005.

[crayon lang=”sql”]
SELECT SERVERPROPERTY(‘productversion’) as productversion
,SERVERPROPERTY(‘productlevel’) as productlevel
,SERVERPROPERTY(‘edition’) as edition
[/crayon]

which returns exactly what you need like

product version         productlevel              edition
——————– ——————– ——————–
9.00.3068.00           SP2                             Developer Edition

For more information read Microsoft Knowledge Base article 321185.
To determine what is the version of SQL Server inctance run query.

[crayon lang=”sql”]select @@version[/crayon]

Then look up the version number up in one of the tables below.

For SQL Server 2005:

@@versionVersion and Service Pack
 9.00.4028.00SQL Server 2005 with service pack 3
9.00.3054.00SQL Server 2005 with service pack 2 GDR2.
9.00.3050SQL Server 2005 with service pack 2 GDR1.
9.00.3042SQL Server 2005 with service pack 2.
2005.90.2047SQL Server 2005 with service pack 1
2005.90.1399SQL Server 2005 with no service pack applied

For SQL Server 2000:

@@versionVersion and Service Pack
8.00.2039SQL Server 2000 with Service Pack 4
8.00.760SQL Server 2000 with Service Pack 3a
8.00.760SQL Server 2000 with Service Pack 3.
8.00.532SQL Server 2000 with Service Pack 2
8.00.384SQL Server 2000 with Service Pack 1
8.00.194SQL Server 2000 with no service pack applied

For SQL Server 7:

versionService Pack
7.00.1063SQL Server 7 with Service Pack 4
7.00.961SQL Server 7 with Service Pack 3
7.00.842SQL Server 7 with Service Pack 2
7.00.699SQL Server 7 with Service Pack 1
7.00.623SQL Server 7 with no service pack applied

For SQL Server 6.5:

versionService Pack
6.50.479SQL Server 6.5 with Service Pack 5a (updated)
6.50.416SQL Server 6.5 with Service Pack 5a.
6.50.415SQL Server 6.5 with Service Pack 5
6.50.281SQL Server 6.5 with Service Pack 4
6.50.258SQL Server 6.5 with Service Pack 3
6.50.240SQL Server 6.5 with Service Pack 2
6.50.213SQL Server 6.5 with Service Pack 1
6.50.201SQL Server 6.5 with no service pack applied

For SQL Server 6:

versionService Pack
6.00.151SQL Server 6 with Service Pack 3
6.00.139SQL Server 6 with Service Pack 2
6.00.124SQL Server 6 with Service Pack 1
6.00.121SQL Server 6 with no service pack applied
Published inMSSQL

Be First to Comment

    Leave a Reply

    Your email address will not be published. Required fields are marked *