System Functions MSSQL Tutorial

The syntax  for sp_HelpRole
sp_HelpRole [[@rolename = ] 'database_role_name']