Trace of Deadlock

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  September 18, 2003 at 8:07 am

  #59485

  How can we view the history of deadlock,After it is over.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  September 18, 2003 at 9:46 am

  #474896

  This isn't the appropriate place for this. Pls post in the admin section.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

  The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

  http://www.dkranch.net

• kerenar

  SSC Rookie

  Points: 28

  More actions

  September 21, 2003 at 7:54 am

  #475174

  run: dbcc traceon(3605,1204,3604) and you will get a lot of information saved on sql server log

  [/quote]