Find SQL Server Install Date

• Vijendran

  SSC Veteran

  Points: 278

  More actions

  August 14, 2009 at 10:05 pm

  #208583

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

• Rudy Panigas

  SSChampion

  Points: 10702

  More actions

  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

• Kari Suresh

  Hall of Fame

  Points: 3712

  More actions

  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

• RML51

  SSCarpal Tunnel

  Points: 4410

  More actions

  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.

• jasonmorris

  SSCrazy

  Points: 2492

  More actions

  May 11, 2010 at 7:39 am

  #1165533

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

• David Diener

  SSC-Addicted

  Points: 410

  More actions

  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
  

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 19, 2016 at 6:59 am

  #1880199

  Thanks for the script.