If you would like to blog on SQLServerCentral.com then send an email to
Some times is necessary retrieve a list of members of the roles of a database. Doing this is simple, using the DMV sys.database_role_members. Below follow an example of how to do this.
Posted in Adeilson Brito
on 12 August 2010