deadlock capture.

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  December 22, 2011 at 9:29 am

  #247980

  We are facing deadlock errors in application logs. but Deadlock events are not getting captured in SQL errorlog. is there any setting for that?

• salum

  SSCommitted

  Points: 1598

  More actions

  December 22, 2011 at 9:32 am

  #1424855

  you have enabled trace flag 1222 to capture deadlock in error log.

  DBCC TRACEON (1222, -1)

  java[/url]

• Roy Ernest

  SSC-Dedicated

  Points: 38780

  More actions

  December 22, 2011 at 9:36 am

  #1424857

  For more information on Deadlock, read this MSDN page.

  -Roy

• Satya_0000

  Mr or Mrs. 500

  Points: 544

  More actions

  December 23, 2011 at 7:52 am

  #1425177

  Thanks All