Search notes:
SQL Server: sys.server_role_members
sys.server_role_members shows the membership of logins in server roles.
The view consists of two columns, only,
role_principal_id and
member_principal_id. Both ids can be joined to
sys.server_principals:
select
-- srm.role_principal_id,
rol.name role_name,
-- srm.member_principal_id,
mbr.name login_name
from
sys.server_role_members srm join
sys.server_principals rol on srm.role_principal_id = rol.principal_id join
sys.server_principals mbr ON srm.member_principal_id = mbr.principal_id;