Hi -

I have questions on deadlock tracing and hope someone can help.

I enabled deadlock trace with dbcc traceon (1222, 1204, -1), and I
want to redirect the result to a log/trace file away from the sql
server error log.

Is there a way and how should it be done? Does it require an instance/
server bounce?

Thanks in advance.

xo (xo5555ox (AT) gmail (DOT) com) writes:
As far as I know this is not possible per se. However, you can set up a
server side trace that include Deadlock Graph as the single event.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx