User Role MSSQL Tutorial

EXEC sp_helpdbfixedrole
GO
EXEC sp_helprolemember
GO