Find SQL Server Install Date

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

  • 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

  • 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

  • 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.

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

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

    Thanks!


    Kindest Regards,

    (Anonymous) SQL Server DBA

  • 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