System Functions MSSQL Tutorial

EXEC sp_DropSrvRoleMember JohnDoe, sysadmin