Post reply

SQL Server Version Info

  • April 24, 2009 at 9:28 am

    #129616

    Hi:

    When I run these two queries they give me different SP info:

    First Query = SELECT @@Version

    Result = Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

    May 3 2005 23:18:38

    Copyright (c) 1988-2003 Microsoft Corporation

    Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

    Note at the end, it says Service Pack 2

    Second Query = select SERVERPROPERTY('ProductLevel')

    Result = SP4

    Thanks

    Of course the engine has SP4, but why the first query says SP2?

    Alberto De Rossi
    Microsoft Certified Solutions Associate - SQL Server
    Microsoft MVP - Data Platform
    Power BI User Group Lima - Community Leader

  • April 24, 2009 at 9:32 am

    #983633

    Service Pack 2 in the @@Version query is referring to the Operating System not SQL.

  • April 27, 2009 at 1:55 am

    #984206

    SELECT @@Version -->OS Service Pack

    select SERVERPROPERTY('ProductLevel')--> SQL Server Service Pack

  • April 27, 2009 at 2:03 am

    #984210

    Alberto De Rossi (4/24/2009)

    Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)

    Major and minor version of SQL as well as the CPU architecture. The 8.00.2039 indicates SQL 2000 service pack 4

    May 3 2005 23:18:38

    The build date of the SQL Server executable

    Developer Edition

    The edition of SQL (Enterprise, Standard, Developer, Express, Evaluation)

    on Windows NT 5.2 (Build 3790: Service Pack 2)

    The version and service pack of the windows operating system that SQL is installed on. In this case, Server 2003 SP2

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 27, 2009 at 3:13 am

    #984227

    Refer following link for further detail:

    http://support.microsoft.com/kb/321185

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • April 27, 2009 at 5:11 am

    #984260

    http://support.microsoft.com/kb/321185

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply