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 12»»

good way to identify when was sql server installed? Expand / Collapse
Author
Message
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: Tuesday, September 2, 2014 6:05 PM
Points: 1,283, Visits: 2,960

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
Posted Thursday, August 16, 2012 2:05 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:13 AM
Points: 1,532, Visits: 2,577

Is create data for Master DB is older than the Server date ?
Post #1345724
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: Tuesday, September 2, 2014 6:05 PM
Points: 1,283, Visits: 2,960
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
Posted Thursday, August 16, 2012 9:23 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
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: Saturday, September 13, 2014 10:46 AM
Points: 360, Visits: 912
This? http://www.sqlservercentral.com/scripts/Miscellaneous/67724/
Post #1346072
Posted Thursday, August 16, 2012 9:51 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
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: Saturday, September 13, 2014 10:46 AM
Points: 360, Visits: 912
If you know when it was installed why would you need to query to find out that which you already know?
Post #1346168
Posted Thursday, August 16, 2012 9:36 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:13 AM
Points: 1,532, Visits: 2,577

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
Posted Friday, August 17, 2012 2:44 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
Thanks joy,

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



Regards
Durai Nagarajan
Post #1346395
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: Saturday, September 13, 2014 10:46 AM
Points: 360, Visits: 912
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 12»»

Permissions Expand / Collapse