Purpose

The purpose of this article is to teach you the process of adding a member to a fixed server role in Microsoft SQL Server 2000.

To Add a Member to a Fixed Server Role

Fixed database roles are defined at the database level and exist in each database. You cannot add, delete or modify fixed database roles. You can only add users as a member of a fixed database role.

Following steps describe you the step by step details of adding a member to a fixed role:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Now, expand Security, and click Server Roles.

3. In details pane, right click the server role for which you want to add a member i.e. Server Administrators.

4. Click Add button to add a member.

5. Now, select a member from the list i.e. john.

6. Click OK.