DONT WORKED!!

I just try it with the scripts bellow:

DBCC TRACEON (3604)

DBCC TRACEON (1204)

GO

begin transaction

   select top 1000000 cod_p   from p (tablockx)

   select top 1000000 p.cod_p,d.cod_d

   from p (tablockx)

   join d (tablockx) on d.cod_d=p.cod_p

commit

DBCC TRACEON (3604)

DBCC TRACEON (1204)

GO

begin transaction

   select top 1000000 cod_d   from d (tablockx)

   select top 1000000 p.cod_p,d.cod_d

   from p (tablockx)

   join d (tablockx) on d.cod_d=p.cod_p

commit

I opnend 2 querys at query analyzer. I succeded to create a deadlock but its dont writed to error log.

Jean, i need some help at lock timeout and deadlock.