Posted by Dan Guzman on 05/28/05 21:08

Specify trace flag 3605 instead of 3604 to write the deadlock info to the
SQL Server error log,

DBCC TRACEON (1205,3605,-1)

--
Hope this helps.

Dan Guzman
SQL Server MVP

"pardhi via SQLMonster.com" <forum@nospam.SQLMonster.com> wrote in message
news:5cc8e2b282894cce84e1ab206f439136@SQLMonster.com...
> Hi Everybody
>
> I am new to sqlserver 2000.I know basics of locks.but i dont know how to
> resolve deadlock issues.I am cofusing by reading articles with 90%
> information and remaining 10% missing.Can any one help me which is the
> good
> site to learn and resolve deadlocks.
>
> Note: I create deadlock. when i try to trace deadlock using dbcc traceon
> (1205,3604,-1).In error log showing nothing about the deadlock.
>
> showing created traceon.........
>
> Any help would be appreciated.
>
> --
> Message posted via http://www.sqlmonster.com

[Back to original message]