Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    145

    Unanswered: Different ways to get sql server version

    Hello,
    We are running sql server 2000 standard edition. According to the article below there are a couple ways to get your version of sql server:

    How to identify your SQL Server version and edition

    It says for sql server 2000 to use:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

    which I did and compared to this table:

    Code:
    Release	Sqlservr.exe
    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
    to which ours said RTM 2000.80.194.0 so we were suprised because we thought we had SP4 installed.

    Now today I used, which is recommended for sql server 6.5 and 7:

    SELECT @@VERSION

    and got:

    Microsoft SQL Server 2000 - 8.00.194 (Intel X86)...(Build 2195: Service Pack 4)

    I'm confused because the first part references the same RTM version, no SPs, but then the last part obviously lists service pack 4. Is the first part just the base version? If so the first method of determining the version is a bit deceiving. So I guess I'm wondering if I interpreted stuff wrong and ultimately want to be confident in what version we have.
    Thanks,
    GG
    Code:
    On Error Goto Hell
    
    Hell:
        Msgbox("An error occurred, but was sent to Hell. You may continue.")

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by gwgeller View Post
    Microsoft SQL Server 2000 - 8.00.194 (Intel X86)...(Build 2195: Service Pack 4)
    Once you know which part is SQL Server and which is Windows Operating System, things become a lot clearer!

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jan 2004
    Posts
    145
    It is so clear now Thanks Pat.
    GG
    Code:
    On Error Goto Hell
    
    Hell:
        Msgbox("An error occurred, but was sent to Hell. You may continue.")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •