Find SQL Server Install Date

  • Vijendran

    SSC Veteran

    Points: 278

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

  • Rudy Panigas

    SSChampion

    Points: 10695

    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

  • Kari Suresh

    Hall of Fame

    Points: 3712

    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

  • RML51

    SSCarpal Tunnel

    Points: 4410

    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.

  • jasonmorris

    SSCrazy

    Points: 2492

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

  • David Diener

    SSC-Addicted

    Points: 400

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

    Thanks!


    Kindest Regards,

    (Anonymous) SQL Server DBA

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

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

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