Does any body has any ideas what the trace flag (3605). We try to test the deadlock in SQL Server 7 but we do not see the error file. The following trace flags was turn on. No error was return but we got the deadlock message. If you have encounter this problem and have solution for it, please share with me. Thank you

Please cc directly to me also:
lamnguyen@platsoft.com

This is the simulate the problem:

dbcc tracestatus(-1)

TraceFlag Status
----------- -----------
1204 1
1205 1
1208 1
1704 1
3604 1
3605 1


first process:

begin tran

update mytitle
set title_id = `abcd`
where title_id = `bu1111`


waitfor delay `00:00:20`
update mytitle
set title_id = `abcd`
where title_id = `bu1032`

commit tran

go

Error return but we cannot see in the server trace flag (3605)

Server: Msg 1205, Level 13, State 17
Your transaction (process ID #20) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.



Second processes:


begin tran

update mytitle
set title_id = `abcd`
where title_id = `bu1032`

waitfor delay `00:00:20`

update mytitle
set title_id = `abcd`
where title_id = `bu1111`

commit tran

go