Tuesday, December 24, 2013

Script to find the SQL Server Installation created Date

select @@SERVERNAME servername,create_date 'InstallationDate' from sys.server_principals

where sid = 0x010100000000000512000000

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful.

No comments:

Post a Comment