Post reply

service pack???

  • January 20, 2006 at 5:44 am

    #89239

    How can I know what service pack the sql server is using???

    Can i do this using Query Analyser???

    I tried using '@@version' but it doesnt give the service pack info.

    please help

    regards,

    Seemita

  • January 20, 2006 at 7:14 am

    #616059

    Hello Seemita,

    You can find out the details by using @@version in Query Analyzer as

    Select @@version

    which will give you information as

    Microsoft SQL Server  7.00 - 7.00.1063 (Intel X86) 

     bla bla bla

    Now based on the above information, go through this webpage to find the service pack that has been applied

    http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185

    Hope this information is helpful to you.

    Thanks and have a nice day!!!


    Lucky

  • January 20, 2006 at 7:50 am

    #616077

    I like querying for the SERVERPROPERTY.

    SELECT ServerProperty('Edition'),

    ServerProperty('ProductVersion'),

    ServerProperty('ProductLevel')

    Refer to the BOL, use the Index tab and enter SERVERPROPERTY for more information on this command.

    -SQLBill

  • January 24, 2006 at 12:21 pm

    #616747

    Alternatively, use EM.  Right click the server instance, select Properties.  Look at "Product version" on the General Tab.

    ~Jeff

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

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