• When you run your process you can track progress by checking the rowcount of the table in sys.partitions with the iso level READ_UNCOMMITTED.

    Did you understand what I meant about offloading the work the trigger does onto the INSERT...SELECT?

    If it is locking the table for too long you may need to break the insert into smaller batches.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato