August 12, 2009 at 10:49 am
rudy komacsar (8/12/2009)
How about one more solution:use master
go
select createdate as 'Sql Server Installation Date'
from sys.syslogins
where sid = 0x010100000000000512000000 -- language neutral for NT AUTHORITY\SYSTEM
go
Very cool, Rudy!
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
August 31, 2009 at 12:27 am
Please find the script in the below link
http://www.sqlservercentral.com/scripts/Miscellaneous/67724/
August 31, 2009 at 9:19 am
rudy excellent script
August 31, 2009 at 7:34 pm
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.
I am not sure if this question was answered: The date of installation does not influence the decommissioning decision. I wanted the installation date to see how long SQL Servers had been going. They are chosen to be decommissioned for other reasons. (Poor management, flaky virtual image, wrong edition/servername/32bit/64bit combination. Basically a clean up and organization of SQL Servers into DEV,SIT,UAT and PROD.)
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply