Prev: SQL 2000 accessing DB2
Next: getting the aggregate from a grouping
From: Chris Wood on 2 Jul 2008 16:08
Hi,

Is there a way to enter more than one condition when you create a filter in
a Profiler Template? I want to enter a number of different application names
in a missing stats template but I cannot see any way to do this using the
GUI.

Thanks

Chris


From: Linchi Shea on 2 Jul 2008 16:19
You should be able to add filtering conditions to a template just as you do a
profiler trace, and then save the template. I just tried it, and it worked as
expected. You can choose which template to edit by going to File -> Templates
-> Edit Template ..., Then, on the Events Selection tab, click on Column
Filters to add filters.

Linchi

"Chris Wood" wrote:

> Hi,
>
> Is there a way to enter more than one condition when you create a filter in
> a Profiler Template? I want to enter a number of different application names
> in a missing stats template but I cannot see any way to do this using the
> GUI.
>
> Thanks
>
> Chris
>
>
>
From: Chris Wood on 2 Jul 2008 17:17
Got it Thanks Linci. I had to double click on the Not Like to give me extra
filters I could add.

Thanks

Chris

"Linchi Shea" <LinchiShea(a)discussions.microsoft.com> wrote in message
news:2AAA35F1-C1BA-41EB-8A3B-6A771057205C(a)microsoft.com...
> You should be able to add filtering conditions to a template just as you
> do a
> profiler trace, and then save the template. I just tried it, and it worked
> as
> expected. You can choose which template to edit by going to File ->
> Templates
> -> Edit Template ..., Then, on the Events Selection tab, click on Column
> Filters to add filters.
>
> Linchi
>
> "Chris Wood" wrote:
>
>> Hi,
>>
>> Is there a way to enter more than one condition when you create a filter
>> in
>> a Profiler Template? I want to enter a number of different application
>> names
>> in a missing stats template but I cannot see any way to do this using the
>> GUI.
>>
>> Thanks
>>
>> Chris
>>
>>
>>


From: Linchi Shea on 2 Jul 2008 17:31
Or you can just type semi-colon (;) to go to the next line.

Linchi

"Chris Wood" wrote:

> Got it Thanks Linci. I had to double click on the Not Like to give me extra
> filters I could add.
>
> Thanks
>
> Chris
>
> "Linchi Shea" <LinchiShea(a)discussions.microsoft.com> wrote in message
> news:2AAA35F1-C1BA-41EB-8A3B-6A771057205C(a)microsoft.com...
> > You should be able to add filtering conditions to a template just as you
> > do a
> > profiler trace, and then save the template. I just tried it, and it worked
> > as
> > expected. You can choose which template to edit by going to File ->
> > Templates
> > -> Edit Template ..., Then, on the Events Selection tab, click on Column
> > Filters to add filters.
> >
> > Linchi
> >
> > "Chris Wood" wrote:
> >
> >> Hi,
> >>
> >> Is there a way to enter more than one condition when you create a filter
> >> in
> >> a Profiler Template? I want to enter a number of different application
> >> names
> >> in a missing stats template but I cannot see any way to do this using the
> >> GUI.
> >>
> >> Thanks
> >>
> >> Chris
> >>
> >>
> >>
>
>
>
 | 
Pages: 1
Prev: SQL 2000 accessing DB2
Next: getting the aggregate from a grouping