where do trace files get put when you turn a flag on? dbcc traceon (1205)

• Greg J

  SSCarpal Tunnel

  Points: 4288

  More actions

  November 17, 2005 at 1:07 pm

  #92253

  I just turned on trace flag 1205 b/c of some deadlocking issues. This in itself isn't going to help me though. Where do I find the file generated? Does it not even create the file until the event has happened?

  Thanks,

  Greg

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 17, 2005 at 1:30 pm

  #604519

  that trace flag does not creates a separate file it simply writes to the sql server error log a more detailed information about deadlocking issues!!!

   

  
  * Noel

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  November 18, 2005 at 11:26 am

  #604707

  If you are performing this fromQA then 1204 will add it to your output.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."