This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The DropMember method removes the specified Microsoft SQL Server user, database role, or login from the role referenced.
Configuring role membership by using the DropMember method of the Database and ServerRole objects requires appropriate permission.
For the Database object, the database user mapped to the SQL Server login used for SQLServer object connection must be a member of the fixed database role db_owner.
For the ServerRole object, the SQL Server login used for SQLServer object connection must be a member of the role from which the specified login will be dropped.