Below you will find the code to get information about the logins. Simply select the text and copy to the Clipboard.
, dbname AS ‘Default Database’
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.