How to remove a SQL Server role (Enterprise Manager)

To remove a SQL Server role

1. Expand a server group; then expand a server.
2. Expand Databases; 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.
5. Confirm the deletion.

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

See Also

Removing a SQL Server Database Role