How to remove a SQL Server role (Enterprise Manager)
To remove a SQL Server role
- Expand a server group, and then expand a server.
- Expand Databases, and then expand the database in which the role exists.
- Click Roles.
- 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.