Sql check roles

USE master  
GO  
SELECT DP1.name AS DatabaseRoleName,   
   isnull (DP2.name, 'No members') AS DatabaseUserName   
 FROM sys.database_role_members AS DRM  
 RIGHT OUTER JOIN sys.database_principals AS DP1  
   ON DRM.role_principal_id = DP1.principal_id  
 LEFT OUTER JOIN sys.database_principals AS DP2  
   ON DRM.member_principal_id = DP2.principal_id  
WHERE DP1.type = 'R'
ORDER BY DP1.name;

Similar codes

6 votes396 views4 answers
Mysql group by month
SQL
0 vote346 views1 answer
Mysql foreach insert
SQL
4 votes350 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
24 votes383 views6 answers
Replace mysql
SQL
-1 vote382 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote366 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote343 views1 answer
Sqlalchemy query join many to many
SQL
0 vote337 views1 answer
Postgres in operator with comma separated values
SQL
1 vote366 views1 answer
Insert value to new table by joining 2 different tables
SQL
3 votes322 views3 answers
Print in pl sql
SQL