SQL Server/T-SQL Tutorial/System Functions/sp HelpRole

A statement that lists the roles for the current database

   <source lang="sql">

EXEC sp_HelpRole</source>

Display database role information:

   <source lang="sql">

The syntax for sp_HelpRole sp_HelpRole [[@rolename = ] "database_role_name"]</source>