SQL Profiler - filtering out empty columns

• Bernd.Bast

  SSC Veteran

  Points: 202

  More actions

  December 17, 2003 at 7:48 am

  #59105

  Hello everybody,

  I have a special question about using SQL Profiler. If you define a filter on e.g. the hostname column to LIKE "HostA" SQL Profiler also displays events where this column is empty and that are a lot. How is it possible to exclude such events?

  Thanx for your help.

  BB.

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  December 17, 2003 at 9:13 am

  #486712

  For me the best way to filter is to save the output into a SQL table and then apply T-SQL commands to filter.

  Also is better and faster to save first into a file, and then export the file into a SQL table with the function fn_trace_gettable.