How to turn off deadlock detection in MSSQL2000 -

» SQL Server » SQL Server Questions » How to turn off deadlock detection in MSSQL2000

How to turn off deadlock detection in MSSQL2000

Last post 06-19-2008 6:21 AM by aprato. 1 replies.

Page 1 of 1 (2 items)
	Sort Posts: Previous Next

06-18-2008 11:22 PM

plauten
Joined on 06-19-2008
Posts 2

How to turn off deadlock detection in MSSQL2000

Reply Contact

Hi,

MSSQL2000 has such a feature that it detects deadlocks and kills one of the transactions which take part in the deadlock. I would like to turn off this feature (for debugging purposes), i.e. make the server not to terminate these transactions (i.e. block forever).

Is there a flag/setting in the DB server how to configure this?

Filed under: sql server, performance, deadlock, detection, mssql, debugging

06-19-2008 6:21 AM In reply to

aprato
Joined on 12-01-2007
Greater Boston
Posts 190

Re: How to turn off deadlock detection in MSSQL2000

Reply Contact

I'm not so sure you can turn this behavior off

You may be better served by turning on trace flag 1204 and capturing the deadlock information to the SQL Server error log

dbcc traceon(1204,-1)

when you're done, turn it off with

dbcc traceoff(1204)

Page 1 of 1 (2 items)