RE: Locking problem
I suspect that FK caused the problem because the new connection is waiting for the other connection to commit and release its locks so that the new conn. can check the inserted FK values for validity. This ought to happen only with trans. iso. level set to 'repeatable read' or higher - UNLESS - ADO […]
2003-07-01