SQL Profiler not excluding events.. Im going to weep !

• Simon_L

  SSCarpal Tunnel

  Points: 4669

  More actions

  January 29, 2009 at 9:08 am

  #204738

  I've exported a SQL profiler trace to code .. amongst a large list of exclusions and the odd inclusion there is an exclusion for a trigger .. that blatantly doesn’t work

  any ideas .. words of wisdom etc etc ?

  exec sp_trace_setfilter @TraceID, 1, 0, 7, N'%DBA_TR%'

  best wishes simon

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  February 3, 2009 at 6:43 pm

  #937659

  Is this resolved?

  MJ

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  February 3, 2009 at 8:39 pm

  #937699

  What is the column you have the filter on?

  Was it filtering the trigger correctly in the Profiler GUI?

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question