How to remove a login from a fixed server role (Enterprise Manager)

How to Install SQL Server 2000

How To

How to remove a login from a fixed server role (Enterprise Manager)

To remove a login from a fixed server role

  1. Expand a server group, and then expand a server.

  2. Expand Security, and then click Server Roles.

  3. In the details pane, right-click the server role to modify, and then click Properties.

  4. On the General tab, select the login to remove, and then click Remove.

See Also

Viewing and Modifying Role Memberships