select * from sys.database_principalsWHERE [type] IN ('S','U')ORDER BY [type]
SELECT name, is_disabled,is_policy_checked, is_expiration_checkedFROM sys.sql_logins;