Hallo Markus,
das geht über sys.database_principal:
SELECT ROL.name AS RoleName
,MEM.name AS MemberName
FROM sys.database_role_members AS DRM
INNER JOIN
sys.database_principals AS ROL
ON DRM.role_principal_id = ROL.principal_id
INNER JOIN
sys.database_principals AS MEM
ON DRM.member_principal_id = MEM.principal_id
Olaf Helper
Blog
Xing
