System Functions MSSQL Tutorial

sp_DropSrvRoleMember [@loginame = ] 'login_ID',
                     [@rolename = ] 'server_role_name'