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

1 vote70 views1 answer
Enable mysql slow query log
SQL
0 vote174 views1 answer
Tsql find procedure with name
SQL
2 votes125 views1 answer
Mysql change data type of column
SQL
3 votes133 views1 answer
RENAME table pl sql
SQL
1 vote106 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote118 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL
1 vote119 views2 answers
How to check if sql query is correct online
SQL
0 vote123 views1 answer
Drop procedure sql
SQL
0 vote129 views1 answer
Executescalar in sql server
SQL
2 votes118 views2 answers
Maximum execution time of 360 seconds exceeded
SQL