Given the rare occurrences and not being able to reproduce it either by myself nor by your DBA friend, I am only able to suggest it is a side effect...

jvkondapalli (2/19/2013)

---

Correct me if I am wrong here.. looks like you are trying to archive data.

How big is the data size in the table?

If the data size is significantly...

Thanks for confirming that - was hoping that might have been READ UNCOMMITTED 🙂

As you would expect, as soon as you insert the data in your audit table the check...

Hi Gail,

In what isolation level is the query that checks the results running? Do you have Read Committed Snapshot on?

Also, have you considered using the DELETE...OUTPUT clause to capture...