-
Not specified
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