Tuesday, January 6, 2015

How do find all sys admin role users


SELECT

SP1.name AS LoginName, SP2.name AS RoleName

FROM

sys.server_role_members SRM,

sys.server_principals SP1,
 
sys.server_principals SP2
 
WHERE

SRM.member_principal_id = SP1.principal_id

AND

SRM.role_principal_id = SP2.principal_id

No comments:

Post a Comment