Mark Forums Read

Filtering trace-textdata by %someword% doesn't work well

Go Back

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Reply

#1

Old

Pedja

Posts: n/a

Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 11:02 AM

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e. %insert%),
I get bunch of other events that don't have anything close to "insert" in the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#2

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#3

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#4

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#5

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#6

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#7

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#8

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#9

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

#10

Old

Andrew J. Kelly

Posts: n/a

Re: Filtering trace-textdata by %someword% doesn't work well - 09-08-2008 , 07:19 PM

You probably have other filters set and they are ORing instead of ANDing.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Pedja" <Pedja (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I noticed strange problem with sql server profiler. When I filter trace by
searching events which contain some word in text data column (i.e.
%insert%),
I get bunch of other events that don't have anything close to "insert" in
the
text data field.
Does anybody have an idea why?
Regards,
Pedja

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.