How to Identify SQL Service Pack Version

Version 9

    Purpose

     

    This document outlines how to identify the installed version of SQL and its current Service Pack.

     

    Using SQLCMD

     

    1.  Open a command prompt window on the machine with SQL installed on it.

     

    2.  Enter the following line, replacing {INSTANCE NAME} with your SQL Instances name:

    sqlcmd -E -S (local)\{INSTANCE NAME}

    (Example: sqlcmd -E -S (local)\SQLEXPRESS)

     

    3.  The command prompt window should present a '1>', here type the following then press enter:

    select @@Version

     

    4.  The command prompt window should present a '2>', here type the following then press enter:

    go

     

    5.  The results will be returned below.

    cmd.png

     

    Using the registry

         

    You can identify the current service pack of an SQL install by viewing the corresponding registry key.

    SQL 2005

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\(Instance Name)\CurrentVersion

     

    CurrentVersion value =
    Gold:9.00.1399.*
    SP1:9.00.2047.*
    SP2:9.00.3042.*
    SP3:9.00.4032.*
    SP4:9.00.5000.*

     

    SQL 2008

    32-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.(Instance Name)\MSSQLServer\CurrentVersion
    64-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL10.(Instance Name)\MSSQLServer\CurrentVersion

     

    CurrentVersion value =
    Gold:10.0.1600.*
    SP1: 10.0.2531.*
    SP2:10.0.4000.*
    SP3:10.0.5500.*

     

    SQL 2008 R2

    32-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.(Instance Name)\MSSQLServer\CurrentVersion
    64-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\MSSQL10_50.(Instance Name)\MSSQLServer\CurrentVersion

     

    CurrentVersion value =
    Gold:10.50.1600.*

    SP1: 10.50.2500.*

    SP2:10.50.4000.*

     

    SQL 2012

    32-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\(Instance Name)\MSSQLServer\CurrentVersion
    64-Bit: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\(Instance Name)\MSSQLServer\CurrentVersion

     

    CurrentVersion value =
    Gold:11.0.2100.*
    SP1:11.0.3000.*

     

    Affected Product(s)


    All