This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a TSQL script to find the installation date, time and authentication mode of SQL Server.
The DBA can use below script to find the detail on server properties for different SQL Servers.
You can also use this to prepare a report for different SQL Servers and can compare the server properties.
1 2 3 4 5 6 7 8 9 |
SELECT createdate AS InstallationDate ,CASE SERVERPROPERTY('IsIntegratedSecurityOnly') WHEN 1 THEN 'Windows Authentication' WHEN 0 THEN 'Windows and SQL Server Authentication' END AS AuthenticationMode ,SERVERPROPERTY('servername') AS ServerName FROM master.sys.syslogins WHERE name LIKE 'NT AUTHORITY\SYSTEM' |