Thursday 22 November 2012

How to Check When SQL Server was installed?

NT AUTHORITY\SYSTEM login gets created when we install SQL Server.

By querying sys.syslogins, we would get an idea of the SQL Server Installation date time.

SELECT createdate AS sql_server_install_date
FROM sys.syslogins
WHERE sid = 0×010100000000000512000000

SELECT * FROM
sys.syslogins
WHERE sid = 0×010100000000000512000000

No comments:

Post a Comment