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 votes173 views2 answers
Oracle find all tables with column name
SQL
0 vote174 views1 answer
Geopoint from json mysql function
SQL
1 vote242 views1 answer
Mysql is odd
SQL
38 votes247 views6 answers
Ubuntu install mysql client
SQL
0 vote176 views1 answer
Check if database exists sql
SQL
0 vote121 views1 answer
Mssql view column data type
SQL
0 vote170 views1 answer
Sql get count without group by
SQL
0 vote167 views1 answer
Sql add calculated column
SQL
0 vote211 views1 answer
Example of sql querry result sepapreted by comma
SQL
1 vote115 views1 answer
Full text index mysql
SQL