version difference SQL server 2000

  • When I check the version of SQL server in Enterprise Manager

    It is showingProduct version:8.00.2039(SP4)

    When I check the version of SQL server in Query analyzer (@@version)

    It is showing Microsoft SQL Server 2000 - 8.00.2039 (Build 3790: Service Pack 2)

    Thanks,

    Bmr

  • It is SP4 according to the version database so, the question has to be are you pointing to the correct instance in Query Analyzer?

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

  • Yes, We have one instance.

  • Tell us what you are doing in each case to check the version.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • we recently applied sp4. It has to show the same version in QA and EM.

    I want to know that, will it create any problem in future?

  • Still waiting for an answer to my question.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]

  • I wrote about this some time ago for SQL 2000. Basically the file extended properties and the version in master could conceivably be different. I'd check both and that might tell you where each tool reads the value from. Might not be the same place.

  • bmr270 (9/18/2008)


    When I check the version of SQL server in Enterprise Manager

    It is showingProduct version:8.00.2039(SP4)

    When I check the version of SQL server in Query analyzer (@@version)

    It is showing Microsoft SQL Server 2000 - 8.00.2039 (Build 3790: Service Pack 2)

    Thanks,

    Bmr

    If I am not mistaken - the versions are the same. SQL Server version 8.00.2039 for both QA and EM.

    The build information is for the OS - Windows NT 5.2 Service Pack 2.

    You can also run the following:

    Select serverproperty('ProductVersion')

    ,serverproperty('ProductLevel');

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

  • Thanks,

    Yes that is windows service pack 2

    Thanks to all for your reply

Viewing 9 posts - 1 through 8 (of 8 total)

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