System Functions MSSQL Tutorial

sp_DropRoleMember [@rolename = ] 'database_role_name',
                  [@membername = ] 'security_account'