Am having a weird, or maybe not so weird problem.
I have a transaction which needs to reference the same table a few times, as well
as others.
It reads a record from this table via an sp, must be sp due to criteria not
involving primary key.
On the second read of the table, the sp hangs and eventually times out.
I suspect that the sp is doing a table scan and thus failing due to the lock
on the first record already in the transaction.
Am I in right-field here ?
P.S. Isolation level of Serializeable, Read-Comitted, Read-Uncomitted all have same
results.
