Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » Administering » good way to identify when was sql server...
Add to briefcase
11 posts, Page 1 of 2
12»»

good way to identify when was sql server installed? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
curious_sqldba
Posted Monday, August 13, 2012 1:01 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:36 PM
Points: 1,168, Visits: 2,679

I am using below query to identify when was sql server installed.

SELECT create_date as 'SQL Server Install Date'

FROM sys.server_principals WHERE name='NT AUTHORITY\SYSTEM'

However when i check the create_Date for master database it doesnt match the install date? I am sure master db wasn't re-installed? Any thoughts and what would be ideal way to identify when was sql server installed?
Post #1344370
Joy Smith San
Posted Thursday, August 16, 2012 2:05 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 1,370, Visits: 2,285

Is create data for Master DB is older than the Server date ?
Post #1345724
curious_sqldba
Posted Thursday, August 16, 2012 8:52 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 2:36 PM
Points: 1,168, Visits: 2,679
Joy Smith San (8/16/2012)

Is create data for Master DB is older than the Server date ?


Yes Masterdb create date is Older than server date..why????
Post #1346031
durai nagarajan
Posted Thursday, August 16, 2012 9:23 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 846, Visits: 2,082
one of our server is 4/8/2003 9:13:36 AM but sql 2005 not released in 2003 , may be this is master db for 2005 build date.

Regards
Durai Nagarajan
Post #1346053
Scott D. Jacobson
Posted Thursday, August 16, 2012 9:38 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841
This? http://www.sqlservercentral.com/scripts/Miscellaneous/67724/
Post #1346072
durai nagarajan
Posted Thursday, August 16, 2012 9:51 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 846, Visits: 2,082
Scott,

it is giving '2011-09-24 00:00:00.000' still not correct, we have installed it on august/september 2007 after that no re install /rebuild.

Regards
Durai Nagarajan
Post #1346086
Scott D. Jacobson
Posted Thursday, August 16, 2012 11:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841
If you know when it was installed why would you need to query to find out that which you already know?
Post #1346168
Joy Smith San
Posted Thursday, August 16, 2012 9:36 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 1,370, Visits: 2,285

I think it's the build date.

Scott D. Jacobson (8/16/2012)
If you know when it was installed why would you need to query to find out that which you already know?


That doesn't make sense. What's wrong in learning some new commands even if you already know what the result would be ? What if his manager ask him to get those details from another server which he's not aware of ?
Post #1346325
durai nagarajan
Posted Friday, August 17, 2012 2:44 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 846, Visits: 2,082
Thanks joy,

just a doubt will the service packs changing the build dates?

Regards
Durai Nagarajan
Post #1346395
Scott D. Jacobson
Posted Friday, August 17, 2012 1:39 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841
Joy Smith San (8/16/2012)

I think it's the build date.

Scott D. Jacobson (8/16/2012)
If you know when it was installed why would you need to query to find out that which you already know?


That doesn't make sense. What's wrong in learning some new commands even if you already know what the result would be ? What if his manager ask him to get those details from another server which he's not aware of ?


OK, that's fair. I guess the original question didn't come off that way. Maybe I misunderstood.
Post #1346732
« Prev Topic | Next Topic »

Add to briefcase
11 posts, Page 1 of 2
12»»

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.