SELECT sp.name, sp.type_desc, sp.create_date FROM sys.server_principals sp, sys.server_role_members srm
WHERE sp.principal_id = srm.member_principal_id AND SRM.role_principal_id = 3
WHERE sp.principal_id = srm.member_principal_id AND SRM.role_principal_id = 3
No comments: