Viewing 6 posts - 46 through 51 (of 51 total)
Oliiii (10/5/2010)
Paul White NZ (10/4/2010)
Oliiii (10/4/2010)[hrIt looks like it knows that even though the record is held by an exclusive lock, it hasn't been modified yet so is not yet...
October 5, 2010 at 9:12 am
Paul White NZ (10/4/2010)
Can I ask *why* you want to block query 2? It seems an unusual requirement. Why would it be bad for query 2 to run...
October 5, 2010 at 4:23 am
Paul White NZ (10/4/2010)
gheinze (10/4/2010)
I tested this on a test Db with isolation level "read committed snapshot"
Right well that's different - now you are using the isolation level correctly.
The point...
October 5, 2010 at 4:13 am
same results with xlock
when I check sp_lock the type of the lock change to RID and mode X but i get the same results using updlock or xlock
October 4, 2010 at 6:28 am
Paul White NZ (10/3/2010)
gheinze (10/1/2010)
The isolation level is read committed with ALLOW_SNAPSHOT_ISOLATIONÂ ON
At the default READ_COMMITTED isolation level, you would need to SET READ_COMMITTED_SNAPSHOT ON to get row versioning isolation.
ALLOW_SNAPSHOT_ISOLATION refers...
October 4, 2010 at 5:02 am
Thanks all for the replies!!
At the default READ_COMMITTED isolation level, you would need to SET READ_COMMITTED_SNAPSHOT ON to get row versioning isolation.
ALLOW_SNAPSHOT_ISOLATION refers to full SNAPSHOT isolation, which requires a...
October 4, 2010 at 4:33 am
Viewing 6 posts - 46 through 51 (of 51 total)