I do like to find the query to list out all the available database role membership identities for msdb database. For other database i pull out the list of database role membership from sys.database_principals whose
principal_id ranges between 16384-16393. For msdb database there seems to be much of database roles and it is not available in sys.database_principals. Kindly help me out in pulling out all the database roles for msdb database alone.
View Complete Post