Problem With Sql Trace

• tom frost

  SSChasing Mays

  Points: 655

  More actions

  September 3, 2004 at 8:52 am

  #85244

  I'm trying to filter out an object name, @tab, which comes through as an EventClass 46, column ID 34, Create Object.

  The code I use in the filter is :

  exec sp_trace_setfilter @TraceID, 34, 0, 7, N'@tab%'

  exec sp_trace_setfilter @TraceID, 34, 0, 7, N'@tab'

  but it still comes through.

  Any Ideas

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  September 3, 2004 at 10:18 am

  #521685

  From above, it is taking @tab as the object name. Don't put @tab in quotes.

• tom frost

  SSChasing Mays

  Points: 655

  More actions

  September 8, 2004 at 9:02 am

  #522133

  Tried your suggestion with different permutaions and still no luck.  Seems like it accespts the @ as a reserved character unless I'm missing something.

  Is the captial N required?  What does that do?

  Code Follows:

  exec sp_trace_setfilter @TraceID, 34, 0, 7, N'#temp'

  exec sp_trace_setfilter @TraceID, 34, 0, 7, N'#temp%'

  exec sp_trace_setfilter @TraceID, 34, 0, 7, N'#%'

  exec sp_trace_setfilter @TraceID, 35, 0, 7, N'tempdb'

  ---exec sp_trace_setfilter @TraceID, 34, 0, 7, N@tab%

  exec sp_trace_setfilter @TraceID, 34, 0, 7, N'"@"tab'

   

  thks

• happycat59

  One Orange Chip

  Points: 29389

  More actions

  September 8, 2004 at 10:06 pm

  #522228

  You probably need to do something like

  exec sp_trace_setfilter @TraceID, 34, 0, 7, @tab

  I assume that the variable @tab contains the value that you wish to filter on.  If you want to use a wild card then this will need to be part of the string assigned to @tab

  e.g. Set @tab = 'objectname%'