dbd_list_login

exec master..dbd_list_login

This procedure lists info about loaded logins and databases. Password column can be set to 'Yes' or 'No':
Yes - password must exactly match to the password specified at setup time.
No - there is no strict password requirements.

Example output:

ID    Database      Login        Password  Windows Group
----- ------------- ------------ --------- --------------
1     test1         login1       No        No
2     test1         login2       Yes       No

dbd_list_login is installed in master database. Items can be added with dbd_add_login and deleted with dbd_del_login