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

0 vote263 views1 answer
Print orcale
SQL
0 vote260 views1 answer
Mysql show foreign keys column
SQL
16 votes269 views2 answers
Oracle ddl
SQL
-1 vote269 views1 answer
Sql add column bit
SQL
4 votes311 views6 answers
Select sql
SQL
0 vote277 views1 answer
MySQL get all previous date record
SQL
27 votes281 views6 answers
Sql update record
SQL
0 vote299 views1 answer
Hour and minute between two datatime sql
SQL
0 vote261 views1 answer
Mysql trim characters
SQL
0 vote234 views1 answer
How to see the content of tables in pgadmin
SQL