Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sixsigma1978
Starting Member
25 Posts |
 Posted - 2009-10-15 : 09:45:12
|
| I'm trying to figure out an example as to how non-repeatable reads can occur in an READ COMMITTED transaction isolation level? (MS SQL SEVER 2008)If a transaction in this isolation level attempt to read from a row that's being modified by another transaction, it waits because of the shared lock, until the original transaction returns. So how is it possible for a non-repeatable read to occur in this isolation level?Can anyone provide me with a use case? |
|
|
|
|
|
Example of how non-repeatable reads can occur?