Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Using SQL Profiler to Resolve Deadlocks in SQL Server RE: Using SQL Profiler to Resolve Deadlocks in SQL Server

  • February 20, 2009 at 11:11 am

    #947721

    You must be connecting to a SQL 2000 server which doesn't have that event. In SQL Server 2000, you have to enable Trace Flag 1204 to get the deadlock graph through the ErrorLog.

    dbcc traceon(1204, -1)

    Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
    My Blog | Twitter | MVP Profile
    Training | Consulting | Become a SQLskills Insider
    Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]