Post reply

Obtaining Service Pack Install Date?

  • August 21, 2006 at 1:22 pm

    #75042

    Hello,

    MSSQL 7/2000/2005

    Is there a system table or method to obtain the service pack install date?

    THanks. Jeff

    Many thanks. Jeff

  • August 22, 2006 at 7:04 am

    #656100

    I do not think that is recorded anywhere in SQL Server.

  • August 22, 2006 at 7:21 am

    #656104

    I think if you look hard enough you can find this in the registry...

    try HKLM\Software\Microsoft\Windows\CurrentVersion\Installer\UserDate\S-1-5-18\Products\

    One of these should be the install for your service pack.  Look in the InstallProperties\InstallDate Key.  It should give you the install date as yyyymmdd.

    -Luke

    To help us help you read this[/url]For better help with performance problems please read this[/url]

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

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