Home Forums SQL Server 7,2000 Administration What is the BEST way to determine the REAL version of SQL 2000?? RE: What is the BEST way to determine the REAL version of SQL 2000??

  • The output of @@Versions confuses so many people. The different colours show what's referring to what.

    Microsoft SQL Server 2000 - 8.00.2055 (Intel X86)

    Dec 16 2008 19:46:53

    Copyright (c) 1988-2003 Microsoft Corporation

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

    Version 2055 appears to be SP4 with some additional hotfixes applied.

    http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx is pretty good and lists SP4 as 2039, you you're a little above that.

    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