Posted by D. on 05/23/07 10:50

I have a question about the "readCommitted" transaction isolation level.

I have a client that is updating a record on a table.
I suspend the execution after the UPDATE but before the commit statement.

Than another client is trying to read the same record.

As transaction isolation is set to "readCommited" I expected that the second
client will read the old version of the record (before the update).
Instead, the second client hangs and wait until the first client do the
commit.
I expect this behavior if transaction isolation is set to "serializable"

Is this behavior correct?

Thanks,
D.

• Next in forum: Re: Question about Transaction isolation level="readCommitted"
• Prev in forum: Re: Transaction log and tempdb
• Thread view: Question about Transaction isolation level="readCommitted"

[Reply to this message]