Can I determine SQL install date using a TSQL script?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » SQL Server 2005 » Administering » Can I determine SQL install date using a TSQL...

Add to briefcase

19 posts, Page 1 of 2

1 2 »»

Can I determine SQL install date using a TSQL script?

Expand / Collapse

Author

Message

Graham.Okely-876987

Posted Tuesday, November 25, 2008 10:36 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, October 26, 2009 1:58 AM
Points: 36, Visits: 132

Is it possible to determine the date SQL was installed using a TSQL script command?

Post #608856

Graham.Okely-876987

Posted Sunday, November 30, 2008 6:57 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, October 26, 2009 1:58 AM
Points: 36, Visits: 132

I would like to know when several SQL Servers were created.

Could it be the date the earliest non system database was created?

select @@servername + ' '+ convert(varchar(20),crdate,111)  + ' '+ [Name] from sys.sysdatabases order by crdate desc

Post #610987

Posted Sunday, November 30, 2008 7:50 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:58 PM
Points: 32,899, Visits: 26,780

Just curious... why do you need to do this?

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #610993

Graham.Okely-876987

Posted Sunday, November 30, 2008 9:34 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, October 26, 2009 1:58 AM
Points: 36, Visits: 132

Mainly because I am decommissioning SQL servers and building some SQL servers concurrently. I want to let people requesting them know that the life of the servers is too short, if in fact, it is. As I am contracting I do not know, for certain, when they were made.

Post #611009

Steve Jones - SSC Editor

Posted Sunday, November 30, 2008 10:06 PM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 2:54 PM
Points: 31,410, Visits: 13,726

The script above should help, but why would that date impact whether or not something was being decommissioned? I'd think it was being used or not.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #611015

Posted Sunday, November 30, 2008 10:40 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

Try looking at the installation folder's creation dates

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #611033

Graham.Okely-876987

Posted Sunday, November 30, 2008 10:51 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, October 26, 2009 1:58 AM
Points: 36, Visits: 132

I think that the ability create virtual servers can mean less thought is going into their design. Therefore they need to be removed. I want to know how long they last. I think we need to plan them better so they last longer.

By the way finding out the installation date via T-SQL means I can run the command across multiple servers. Then there is no need to go to windows explorer for folder date in each instance.

Post #611034

Posted Sunday, November 30, 2008 10:54 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855, Visits: 9,374

rbarryyoung (11/30/2008)

Try looking at the installation folder's creation dates

This can be done from SQL server.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc. "Performance is our middle name."

Post #611036

Graham.Okely-876987

Posted Sunday, November 30, 2008 10:59 PM

SSC Rookie

Group: General Forum Members
Last Login: Monday, October 26, 2009 1:58 AM
Points: 36, Visits: 132

Is that using DIR ? How would you get that to work over different install paths?

Post #611038

Posted Monday, December 01, 2008 5:19 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:58 PM
Points: 32,899, Visits: 26,780

Ummmm... you may want to double check the methods above if these are, in fact, virtual machines... even the installation folders may contain nothing but an image of what the "mother" VM machine has on it... could be real deceiving. Not sure where to look on VM machines, but can find out at work, today.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #611207

« Prev Topic | Next Topic »

Add to briefcase

19 posts, Page 1 of 2

1 2 »»

Permissions

Expand / Collapse