Viewing 3 posts - 1 through 3 (of 3 total)
Hari.Sharma (7/4/2008)
Read the Last para of the problem mentioned earlier.
There is clearly mentioned that Single statement is updating multiple rows and lock is also there.
It may be the...
July 14, 2008 at 10:36 am
Trigger (7/2/2008)
Secondly, how have you ascertained that process 2 is blocked by process 1
Thirdly, How did you disable page locks and...
July 3, 2008 at 12:37 pm
Hi,
These transaction will create DeadLock.
To avoid Deadlock, You can do serialization.
I don't understand why these should deadlock. The where clause is specifying two completely different sets of rows....
July 3, 2008 at 12:25 pm
Viewing 3 posts - 1 through 3 (of 3 total)