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