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

From: David Gugick (davidg-nospam_at_imceda.com)
Date: 12/31/04 

Date: Fri, 31 Dec 2004 03:43:21 -0500

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: Logging
    ... > Can you explain a little more what you mean about TextData Column ... You'll need to read up on Profiler in BOL. ... columns of data you can capture from a trace. ... Add a filter for the users on the LoginName (make sure the filter works ...
    (microsoft.public.sqlserver.server)
  • Re: [PATCH 0/3] ftrace: updates for tip
    ... I added a "trace" flags field in the task structure. ... The second patch uses this for the ftrace pid code. ... Regarding the filter functions, ... to only specify the PID, ...
    (Linux-Kernel)
  • 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: Problem using SP_TRACE_SETFILTER - it doesnt seem to apply th
    ... I was intimating that you open profiler and set the filter ... I don't dispute that your trace runs fine. ...
    (microsoft.public.sqlserver.server)
  • Re: Continuous Network Diagram for a Single Task
    ... Go to my website and download the "Trace" macro. ... Now switch to the network diagram. ... >From the project menu select filtered for, ...
    (microsoft.public.project)