While using a database you may need to list the members of a database role or fixed server role. Additionally, when a Microsoft® SQL Server™ user no longer needs the permissions from a user-defined, fixed database or server role of which he or she is a member, you can remove the user from the role to keep the security system as simple as possible.
To view the members of a database role (fixed or user-defined)
To remove a user account from a database role (fixed or user-defined)
To view the members of a fixed server role
To remove a login from a fixed server role