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

5 votes367 views1 answer
Mysql count newlines in field
SQL
2 votes356 views2 answers
HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN
SQL
0 vote340 views1 answer
Sql inserted
SQL
0 vote372 views1 answer
Geopoint from json mysql function
SQL
0 vote345 views1 answer
Oracle exchange partition
SQL
0 vote393 views1 answer
Sql sort ages
SQL
-1 vote326 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote326 views1 answer
Oracle sql date summer time
SQL
0 vote352 views1 answer
SQL loop with cursor
SQL
4 votes340 views3 answers
Mysql varchar length
SQL