How to remove a SQL Server role (Enterprise Manager)

To remove a SQL Server role

1. Expand a server group, and then expand a server.
   
   
2. Expand Databases, and then expand the database in which the role exists.
   
   
3. Click Roles.
   
   
4. In the details pane, right-click the role, and then click Delete.

   Note  You must drop all role members before you can delete the role. Fixed roles cannot be deleted.

5. Confirm the deletion.

See Also

Removing a SQL Server Database Role