|
|
Posted by Erland Sommarskog on 05/28/05 21:16
Dan Guzman (guzmanda@nospam-online.sbcglobal.net) writes:
> Specify trace flag 3605 instead of 3604 to write the deadlock info to the
> SQL Server error log,
>
> DBCC TRACEON (1205,3605,-1)
And to make it even better, use 1204, not 1205. 1205 writes deadlock
information as well I believe, but on an extremely detailed level.
Unfortunately, the output from 1204 is cryptic, and far from trivial
to understand.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|