API tools faq
paste
PtiTom

SQL Server - ListLogins

PtiTom
May 23rd, 2020
148
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.18 KB | None | 0 0
raw download clone embed print report
  1. SELECT * FROM sys.syslogins sl
  2. RIGHT OUTER JOIN sys.server_principals sp on sp.SID = sl.SID
  3. LEFT OUTER JOIN sys.server_role_members srm ON srm.role_principal_id = sp.principal_id
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!