Post reply

Service Pack

  • August 1, 2006 at 4:36 am

    #75026

    Hi gurus,

    I have a question regarding the SP's:-

    1. When i execute the command:

    Select @@version

    Output is :Microsoft SQL Server  2000 - 8.00.929 (Intel X86)   Apr  6 2004 11:46:57   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    2. When i execute the command:

    Select Serverproperty('ProductLevel')

    Output is : SP3

    So how to conclude the SQL Server is having which SP Installed.

    Kindest Regards,

    Jeetendra

  • August 1, 2006 at 5:57 am

    #652549

    Refer to

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

    Far away is close at hand in the images of elsewhere.
    Anon.

  • August 2, 2006 at 7:59 am

    #652813

    You are on SP3, the bit at the end stating you are on SP4 is referring to your OS.  The relevant part of the output of @@version for your SLQ build is: Microsoft SQL Server  2000 - 8.00.929

    Its pretty confusing to have the windows service pack number there but not state the sql server service pack too but I guess thats a minor issue in the grand scheme of things.

  • August 2, 2006 at 7:33 pm

    #652973

    SQLSecurity.com's version database is useful. Let's you know which hotfixes are installed as well.

    http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

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