SQL Profilier - Triggers

• sthornton

  Ten Centuries

  Points: 1333

  More actions

  April 27, 2006 at 12:37 am

  #167864

  Hi,

  Is it possible to log the excution of sql that is processed inside triggers?

  What events do I need to capture?

  Thanks,

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  April 27, 2006 at 6:30 am

  #634545

  afaik you need the t SQL events.

  [font="Comic Sans MS"]The GrumpyOldDBA[/font]
  www.grumpyolddba.co.uk
  http://sqlblogcasts.com/blogs/grumpyolddba/