sp_trace_setfilter

• amitmehra

  Newbie

  Points: 9

  More actions

  September 23, 2008 at 5:02 pm

  #876065

  I having similar problem as defined, I am trying to filter the trace based on user role, the trace should capture details for sysadmin role only

  I have set the filter as given below

  exec sp_trace_setfilter @TraceID, 38, 0, 6, N'sysadmin'

  but the filter does not work.

  I did not understand the fix that you are suggesting, could you please explain on what kind of sorting is required

  Thanks

  Amit