Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM sys.syslogins sl
- RIGHT OUTER JOIN sys.server_principals sp on sp.SID = sl.SID
- LEFT OUTER JOIN sys.server_role_members srm ON srm.role_principal_id = sp.principal_id
RAW Paste Data