Complete a Server Assessment – Login Information

Below you will find the code to get information about the logins.  Simply select the text and copy to the Clipboard.

SELECT LoginName
, CreateDate
, dbname AS ‘Default Database’
, Language
, Denylogin
, IsNtName
, IsNtGroup
, IsNtUser
FROM syslogins

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.