SQL Profiler / DBCC Traceon (1204)

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Dan (anonymous_at_discussions.microsoft.com)
Date: 03/01/04


Date: Mon, 1 Mar 2004 11:10:59 -0800


Presently I have my SQL Server set with DBCC Traceon (1204)
to collect deadlock information. I would like to collect
detail information on each deadlock. Is there away to
have SQL Profiler start on a deadlock and collect detail
information?

Thank You,

Dan