profile trace triggers

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  October 5, 2007 at 10:19 am

  #95404

  Is it poosible to create a trace using SQL 2000 that will just return the names of any triggers that fire during a process ?

  many thanks

  ~si

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736478

  More actions

  October 7, 2007 at 8:58 pm

  #739870

  I don't think this is possible. You can filter by table, which could help if you know the tables with triggers, but I don't think this is possible.

  What are you trying to achieve? Perhaps we can help.