Re: Problem using SP_TRACE_SETFILTER - it doesn't seem to apply th

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 11:25:27 -0500

Wanderer wrote:
> OH, btw,
>
> I found that after properly creating those filters, when I open the
> trace file created by my SP, in profiler, I DO see the filters under
> the properties tab for the trace.
>
> Just FYI
>

Strange. I don't see them on some test traces I just ran. Are you saying
that you run a server-side trace, stop the trace, open the trace file in
Profiler, and then see the trace filters? I can't see it here using that
method.

Any verification appreciated.

Thanks 

-- 
David Gugick

Relevant Pages

  • Re: SQL Profiler Filters
    ... I'm assuming you closed Profiler, or at least the window the trace was ... If all you have left is the trace file, ... SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Profiler revolving records
    ... Though I prefer to use the Profiler interface, ... > understanding that this option will create a trace file that only contains ... > the last 5 MB of trace information. ... > "Quentin Ran" wrote in message ...
    (microsoft.public.sqlserver.server)
  • Re: Log queries made through SQL manager only ?
    ... Then run a trace that filters on the application. ... Then you will see everything for only SSMS. ... do this full time you will want to use TRACE instead of profiler and send ...
    (microsoft.public.sqlserver.security)
  • Re: Problem using SP_TRACE_SETFILTER - it doesnt seem to apply th
    ... Just before I add the filters, I exec: ... In other words, I start the trace, hence I cannot apply filters. ... > server-side trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Problem using SP_TRACE_SETFILTER - it doesnt seem to apply th
    ... I found that after properly creating those filters, when I open the trace ... file created by my SP, in profiler, I DO see the filters under the properties ... > server-side trace. ...
    (microsoft.public.sqlserver.server)