Make SQL Profiler *NOT* show events with blank application names?

I want SQL Profiler to show me events for 1 specific application. Currently,
I can get it to show me events for that application along with all events
that have no application name. I've tried having just an ApplicationName
LIKE <my-application-name> filter (no NOT LIKE filter), or having an
ApplicationName LIKE <my-application-name> and NOT LIKE '% %' (I couldn't
get it to take just a blank), but I still get events for applications with
no name. Any other ideas? Thanks.
Rick
--
Rick Genter
Sr. Software Engineer
Silverlink Communications
rgenter@.silverlink.com.REMOVERick Genter (rgenter@.silverlink.com) writes:
> I want SQL Profiler to show me events for 1 specific application.
> Currently, I can get it to show me events for that application along
> with all events that have no application name. I've tried having just an
> ApplicationName LIKE <my-application-name> filter (no NOT LIKE filter),
> or having an ApplicationName LIKE <my-application-name> and NOT LIKE '%
> %' (I couldn't get it to take just a blank), but I still get events for
> applications with no name. Any other ideas? Thanks.
I've battled with this myself, but without success. I either end with
filtering on something else, or removing events which does not fill
the column.
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp|||That's what I was afraid of. Thanks, Erland.
"Erland Sommarskog" <sommar@.algonet.se> wrote in message
news:Xns94659E447C26Yazorman@.127.0.0.1...
> Rick Genter (rgenter@.silverlink.com) writes:
> > I want SQL Profiler to show me events for 1 specific application.
> > Currently, I can get it to show me events for that application along
> > with all events that have no application name. I've tried having just an
> > ApplicationName LIKE <my-application-name> filter (no NOT LIKE filter),
> > or having an ApplicationName LIKE <my-application-name> and NOT LIKE '%
> > %' (I couldn't get it to take just a blank), but I still get events for
> > applications with no name. Any other ideas? Thanks.
> I've battled with this myself, but without success. I either end with
> filtering on something else, or removing events which does not fill
> the column.
>
> --
> Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
> Books Online for SQL Server SP3 at
> http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp