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 ServerNameFROM master.sys.syslogins WHERE name LIKE 'NT AUTHORITY\SYSTEM'







.gif)
0 Comments