Blank hostname in profiler, anyone got a workaround?

Doing a profile on a server, I'm getting blank hostnames coming through. I
think we've found that they're coming from some legacy ColdFusion code.
However, when I profile and set a filter of a specific hostname, I still get
line entries that have empty hostnames.
The only item in the MS Support site talks about system processes, which
these are not.
Anyone know of a way to filter out these entries that I do not want to see?Technically, they are NULL, not blank. The Profiler GUI presents them as
blanks. Unfortunately, NULL matches any filter condition, so NULL fields
get through. You can dump the Profiler output to a SQL table and do some
querying on it to improve your filtering capabilities.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Patrick Parker" <pparker@.motivaction.com> wrote in message
news:uGysrkq5DHA.1504@.TK2MSFTNGP12.phx.gbl...
> Doing a profile on a server, I'm getting blank hostnames coming through.
I
> think we've found that they're coming from some legacy ColdFusion code.
> However, when I profile and set a filter of a specific hostname, I still
get
> line entries that have empty hostnames.
> The only item in the MS Support site talks about system processes, which
> these are not.
> Anyone know of a way to filter out these entries that I do not want to
see?
>
>