• If I get the timing, then yes. I don't believe a batch insert "reserves" any numbers, so it's possible.

    If you are concerned, I'd do this
    - dbcc reseed to max + 1010 (allow for some activity between query MAX() and dbcc)
    - run DTS