Find SQL Server Install Date

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Vijendran R » Find SQL Server Install Date

Find SQL Server Install Date

Rate Topic

Display Mode

Topic Options

Author

Message

vijendran

Posted Friday, August 14, 2009 10:05 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, April 22, 2013 9:46 AM
Points: 84, Visits: 421

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

Post #771401

Rudy Panigas

Posted Monday, August 24, 2009 9:27 AM

Old Hand

Group: General Forum Members
Last Login: Friday, June 14, 2013 6:35 AM
Points: 306, Visits: 1,020

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

Post #776100

Kari Suresh

Posted Thursday, May 06, 2010 11:35 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 01, 2013 11:12 PM
Points: 248, Visits: 372

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

Post #917626

RML51

Posted Friday, May 07, 2010 7:53 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 9:46 AM
Points: 1,269, Visits: 1,492

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.

Post #917973

jasonmorris

Posted Tuesday, May 11, 2010 7:39 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 28, 2013 6:15 AM
Points: 381, Visits: 1,384

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

Post #919676

David Diener

Posted Thursday, July 08, 2010 10:25 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, June 03, 2013 8:20 AM
Points: 14, Visits: 200

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

Kindest Regards,

(Anonymous) SQL Server DBA

Post #949431

« Prev Topic | Next Topic »

Permissions