SQLTeam.com | Weblogs | Forums

Server creation date

Hello all,

I would like to create a script that will tell me when a SQL server was created by the hostname , ip address or something. if possible. Can someone give me some direction on where to start. I have the following query, not sure if the creation date is correct.
Select * from sys.syslogins where name = "NT AUTHORITY\SYSTEM'

Try this

SELECT create_date

FROM sys.server_principals

WHERE sid = 0x010100000000000512000000