Re: SQL Profiler Filters

From: Kalen Delaney (replies_at_public_newsgroups.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 13:39:15 -0800

Hi Derek

I am had some problems with multiple filters working correctly together,
especially when you include negatives. There may be a bug in the trace
engine itself or it may be a bug in how Profiler translates your filters to
an underlying trace.

What version are you using? (That info should always be included when asking
for help.)

I presume from your subject line you are using Profiler, and not a server
side trace. Can you see what trace command your filters are being converted
to?
If you are using SQL 2000, you can. Use the option on the profiler menu to
script the trace, and save the script to a file. Then show us the lines from
the script that include sp_trace_setfilter. 

-- 
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Derek Ruesch" <DerekRuesch@discussions.microsoft.com> wrote in message 
news:34906C19-26EE-4926-B80F-B6B4E0C45879@microsoft.com...
>I have a SQL Profiler trace that has the following filters applied:
>
> Application Name  Not Like  SQL Profiler
> TextData  Not Like  SELECT
>
> I want this trace to not include SQL Profiler events and SQL "Select"
> statements.
>
> The trace does not show SQL Profiler events but it does still show 
> "Select"
> SQL statements. Why is it still showing SQL Select statements?
>
> Thanks for the help.
>
> Derek Ruesch

Relevant Pages

  • RE: SQLXML problems
    ... If it is an SQL server's error ... Generally we can use SQL Profiler to do the trace. ... "This posting is provided "AS IS" with no warranties, ...
    (microsoft.public.data.oledb)
  • Re: Profiler logging SP:Starting hundreds of times for one SP
    ... However, when we trace it using SQL Profiler, it reports ... It looks like you have a function on a column in the query. ...
    (microsoft.public.sqlserver.tools)
  • Re: Need help with Sql Profiler
    ... procedure to define the trace, create it, and get a handle to it. ... I decided to use sql profiler with objects events auditing ...
    (microsoft.public.sqlserver.tools)
  • Re: Access Linked server generates (Error 7399) - Help!
    ... See "Monitoring with SQL Profiler" in SQL Books Online, ... other applications running on the server. ... >> Did you try putting a SQL Profiler trace on the job? ...
    (microsoft.public.data.oledb)
  • Re: Simple timeout problem
    ... Brian, I haven't found anything specific on this error. ... We'd want to limit the trace to just the BizTalkRuleEngineDB. ... To run a trace go to SQL Profiler (under the SQL Server entry in the start ... | are reporting a timeout condition trying to connect to the SQL database. ...
    (microsoft.public.biztalk.general)