Post reply

Find SQL Server Install Date

  • August 14, 2009 at 10:05 pm

    #208583

    Comments posted to this topic are about the item Find SQL Server Install Date

  • August 24, 2009 at 9:27 am

    #1043714

    Very nicely done. This is a great way to tell how old the installation is.

    I've having a problem with the execution on a SQL2005 (only tested one server). I get the installation dates but before it's displayed I get the following errors

    RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'

    Msg 22001, Level 1, State 1

    RegOpenKeyEx() returned error 2, 'The system cannot find the file specified.'

    Msg 22001, Level 1, State 1

    ServerName

    My server is a x64 and has several instances installed onto it.

    Comments?

    Rudy

    Rudy

  • May 6, 2010 at 11:35 pm

    #1163798

    Really nice script buddy.. Thanks for the post..

    KSB
    -----------------------------
    Thousands of candles can be lit from a single candle, and the life of the candle will not be shortened. Knowledge and happiness never decreases by being shared.” - Buddha

  • May 7, 2010 at 7:53 am

    #1164107

    I noticed that, if you've installed multiple instances, over time, it only reports the date that the last instance was installed on the server.

  • May 11, 2010 at 7:39 am

    #1165533

    Looks more like the last service pack date to me i'm afraid.

  • July 8, 2010 at 10:25 am

    #1190360

    Do you have a script that works with SQL Server 2000, 2005 and 2008?

    Thanks!

    Kindest Regards,

    (Anonymous) SQL Server DBA

  • May 19, 2016 at 6:59 am

    #1880199

    Thanks for the script.

Viewing 7 posts - 1 through 6 (of 6 total)

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