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 votes284 views2 answers
Find mysql version linux
SQL
0 vote252 views1 answer
Store query result in variable sql
SQL
0 vote295 views1 answer
Uncheck constraints and delete from table
SQL
0 vote297 views1 answer
Example database query
SQL
0 vote283 views1 answer
Drop constraint in ms sql
SQL
1 vote253 views2 answers
Mysql SELECT
SQL
1 vote270 views1 answer
Oracle create program if no exists
SQL
0 vote295 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote264 views1 answer
How to check which sp is running in sql server
SQL
3 votes457 views6 answers
Sql unique select
SQL