Blocking Question

We have a puzzling situation where doing a series of Inserts will block. The user has a transaction consisting of 4 inserts then has to confirm and we commit. If a second user starts the same sequence, the 4th insert will block until the first user commits. Our database people felt that there was a problem with foreign keys and indexes. Googling turns up lots of info on this.

So, after an unsuccessful series of tests designed to locate the offending key, they disabled all of the foreign keys. Still blocked. So here's the question -- What other things will cause an insert to block? These are all new rows being inserted and each user has a different set of rows. And there are some triggers on a row insert.

TIA, Mike P Received on Thu Aug 18 2005 - 16:50:20 CDT