Post reply

Installation / Latest patch/hotfix applied date on SQL Server 2005

  • May 8, 2008 at 7:26 am

    #190180

    Hi SQL Experts,

    what is the query to find the installation date or latest service pack / hotfix applied date of SQLServer 2005 ?

    Any objects stores this details in mssqlserverresource / master database 😀 or we have to get it from Registery 😉 ?

    Thanks in advance.

    Regards

    Marimuthu

  • May 8, 2008 at 9:12 am

    #812474

    I don't think there's a way to do this. You can check the build # and then check against a list, but the individual fixed are not stored, AFAIK, in SQL Server.

    http://www.sqlservercentral.com/articles/Administration/2960/

  • May 8, 2008 at 9:42 am

    #812506

    Thanks for the update Steve.

    We used to get the installation date using following query in SQL Server 2000

    Use Master

    declare @root varchar(50)

    exec XP_regread @rootkey='HKEY_LOCAL_MACHINE', @key='SOFTWARE\Microsoft\MSSQLServer\setup', @value_name='SQLPath', @value = @root OUTPUT

    exec xp_getfiledetails @root

    I believe if we provide the correct key value we can get the installation date.

    Any alternate method is always welcome.

    Regards

    Marimuthu

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

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