I need to write stored procedure which can create Role with name which has been passed in that and in particular database.Also it assign permission to those role explicetly what we gives including xp_sendmail.
Can any one help to do this task?

Thanks in advance.