Posted by Joe Weinstein on 02/04/06 02:48

Hi.

create table joe(c1 integer not null, c2 integer not null)

Two sessions:

Session 1:
BEGIN TRAN
insert into joe (c1,c2) values (1,2)


Session 2:
BEGIN TRAN
insert into joe (c1,c2) values (3,4)

Session 1:
select * from joe

Session 2:
select * from joe

One of the sessions gets a deadlock victim message.
thanks,
Joe

[Back to original message]