Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Find SQL Server Install Date Expand / Collapse
Author
Message
Posted Friday, August 14, 2009 10:05 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 19, 2013 5:44 AM
Points: 84, Visits: 424
Comments posted to this topic are about the item Find SQL Server Install Date
Post #771401
Posted Monday, August 24, 2009 9:27 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Today @ 8:25 AM
Points: 312, Visits: 1,108
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
Posted Thursday, May 6, 2010 11:35 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 22, 2013 1:05 AM
Points: 248, Visits: 373

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
Posted Friday, May 7, 2010 7:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, February 4, 2014 9:35 AM
Points: 1,277, Visits: 1,612
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
Posted Tuesday, May 11, 2010 7:39 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 3:38 AM
Points: 383, Visits: 1,482
Looks more like the last service pack date to me i'm afraid.
Post #919676
Posted Thursday, July 8, 2010 10:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, August 22, 2014 2:29 PM
Points: 14, Visits: 226
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 »

Add to briefcase

Permissions Expand / Collapse