• I'm sure this is not the case, but thought I should mention: make certain the ID column in your audit table is not a identity column.

    ----------------------------------------------------