filtering by null value in profiler?

[ryansupak]

hi,

in sql profiler, under File|Properties|Filters, you can set it to filter the output by either Like <argument> or Not Like <argument>. all i want it to do is to ignore any event where TextData is blank. i've tried &quot;Not Like %%&quot;, &quot;Not Like % %&quot;, and &quot;Not Like ''&quot;. any other ideas?

thanks in advance,
rs

 

[tlbroadbent]

That's a shortcoming of trace that I haven't found a way to overcome. Trace filters cannot be NULL or Empty String. You want to eliminate NULL but there is no trace filter for that. If someone else has a solution, I'd love to hear it. Let's hope the next version of SQL Server addresses the issue. If you want to get the best answer for your question read faq183-874.

Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[ryansupak]

hi,

i think i've got it.

&quot;Like %&quot; seems to eliminate all those nasty nulls.

thanks,
rs

 

[ryansupak]

ugh-

except for that it seems to disregard all of the &quot;Not Like&quot; filters in that case...

still trying...
rs