SQL Profiler "not like" textdata filter not working

• tshad

  SSCertifiable

  Points: 5905

  More actions

  March 2, 2016 at 3:43 pm

  #308960

  I am trying to set up a trace that will not display certain RPC's or SP's

  When I set up the TextData columns "Not Like" selection to have the following 2 filters:

  exec sp_reset_connection

  %PD.%

  This works fine but if I add one more to handle square brackets around the "PD.", it doesn't show any rows.

  It now shows:

  exec sp_reset_connection

  %PD.%

  %[PD.%

  I should get the same 10 rows I got before but I now don't get any.

  Why would that be?

  I would assume it would be looked at as:

  I want to see all the rows that do not have the TextData column equal to "exec sp_reset_connection" and does not contain "PD." or "[PD.]".

  Thanks,

  Tom

• tshad

  SSCertifiable

  Points: 5905

  More actions

  March 2, 2016 at 3:56 pm

  #1862599

  Actually the 3rd filter I was using was:

  %[PD].%

  So all three were:

  exec sp_reset_connection

  %PD.%

  %[PD].%

  I think it has something to do with the [].

  If I take the "[" out it works fine and won't show any of these.

  exec sp_reset_connection

  %PD.%

  %PD].%

  Why does the square brackets "[]" cause a problem?

  Thanks,

  Tom

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  March 2, 2016 at 8:02 pm

  #1862623

  "[ ]" are wildcard characters used in LIKE.

  Check BOL for the correct syntax of the operator and see how to use it properly:

  https://msdn.microsoft.com/en-us/library/ms179859.aspx

  _____________
  Code for TallyGenerator

• tshad

  SSCertifiable

  Points: 5905

  More actions

  March 3, 2016 at 11:57 am

  #1862882

  That explains it.

  Thanks,

  Tom