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

From: Wanderer (Wanderer_at_discussions.microsoft.com)
Date: 01/03/05 

Date: Mon, 3 Jan 2005 02:55:03 -0800

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

"David Gugick" wrote:

> Wanderer wrote:
> > Ok - so it seems that, for some reason, the sp_trace_setfilter is not
> > working. Going to try and build in some logic to catch and check why.
> > Anything that you can see from my SP, that points the way, I'd
> > appreciate hearing it.
> >
>
> You wouldn't see the filter in Profiler if you opened a TRC file after a
> server-side trace. All you see in Profiler is the events captured during
> the trace. The other information (filters) are not saved anywhere in the
> trace file.
>
> Also, I assume when you ran the following statement, you knew that the
> running trace had a handle of 1? It seems unlikely that the handle would
> be 1 unless you just cycled the server.
> SELECT * FROM ::fn_trace_getfilterinfo(1)
>
> I can't read your script file because of the wrapping. What events did
> you capture that are not showing the filter applied?
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
>

Relevant Pages

  • Re: Trace To Table Error MSG 568
    ... I tried stopping the trace but that did not help. ... It sounds like you are using rollover files. ... question if you are using Profiler for this. ... You'll have better control using a server-side trace. ...
    (microsoft.public.sqlserver.programming)
  • 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: SQL Profiler - error saving trace file
    ... > I assume you mean you ran the trace in the Profiler Gui and then are ... > trace that will dump directly to disk without using Profiler at all. ... one for the server-side trace and another that ships rowsets ...
    (microsoft.public.sqlserver.tools)
  • Re: Problem using SP_TRACE_SETFILTER - it doesnt seem to apply th
    ... server-side trace. ... All you see in Profiler is the events captured during ... you capture that are not showing the filter applied? ...
    (microsoft.public.sqlserver.server)