We use a table named LNUs (LastNumbersUsed) with an integer value for LNU. There is a trigger on the table to update the LNU = LNU + 1 from deleted and the current value of LNU is taken and then updated by a delete statement.