How to find your version of SQL Server

You have 2 options.

  1. You can run the following SQL query:

    SELECT SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

  2. You can check the version of the sqlservr.exe file, below is a list of how the version breaks down:

    SQL Server 2005

    SQL Server 2005 RTM 2005.90.1399
    SQL Server 2005 Service Pack 1 2005.90.2047
    SQL Server 2005 Service Pack 2 2005.90.3042

    SQL Server 2000

    SQL Server 2000 RTM 2000.80.194.0
    SQL Server 2000 SP1 2000.80.384.0
    SQL Server 2000 SP2 2000.80.534.0
    SQL Server 2000 SP3 2000.80.760.0
    SQL Server 2000 SP3a 2000.80.760.0
    SQL Server 2000 SP4 2000.8.00.2039