Post reply

Version of Services of MS SQL SERVER 2005

  • November 22, 2010 at 6:57 am

    #147723

    Hi,

    I have installed sql server 2005 without installing the sql server reporting services with service pack 2 on the server. Now server is ready with service pack 2.

    After some time i have installed the sql server reporting services on the sql server instance now i want to find the service pack version of the each services.

    how can find the service pack level of the each sql server 2005 services on the server ?

    ex: database engine ,reporting services etc...

  • November 22, 2010 at 8:03 am

    #1253758

    You connect to SSIS, SSRS using SSMS. After connecting at the right side of the service, the version information is displayed as in this screenshot.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 22, 2010 at 9:28 am

    #1253828

    Adiga (11/22/2010)

    You connect to SSIS, SSRS using SSMS. After connecting at the right side of the service, the version information is displayed as in this screenshot.

    Thanks for your reply...

    Is there any way to find this versions through t-sql query ?

  • November 22, 2010 at 9:42 am

    #1253839

    Here are some of the options for SSIS.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • November 22, 2010 at 5:23 pm

    #1254123

    select SERVERPROPERTY('productlevel')

    gives service pack info in SSMS

    So connect all through SSMS and find it for both database services and reporting.

    Regards,

    Pavan Srirangam

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

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

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