SQL Server Role

SELECT
  login_name = pa.name,
  --pa.principal_id, m.member_principal_id, m.role_principal_id,pb.principal_id,
  role_name = pb.name
FROM
  sys.server_principals pa
  INNER JOIN
  sys.server_role_members m ON pa.principal_id = m.member_principal_id
  INNER JOIN
  sys.server_principals pb ON m.role_principal_id = pb.principal_id
ORDER BY
  pa.name,
  pa.principal_id