How to remove a SQL Server role (Enterprise Manager)

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.

See Also

Removing a SQL Server Database Role