A statement that lists the roles for the current database : sp_HelpRole « System Functions « SQL Server / T-SQL Tutorial






EXEC sp_HelpRole
25.45.sp_HelpRole
25.45.1.Display database role information:
25.45.2.A statement that lists the roles for the current database