"Andre Gibson" wrote:

> I stsrted a trace on one of my bds and it is creating mulitple 5 mb files. I
> thought it would stop once I closed the profiler. WRONG!!!
>
> How can I stop this?

"P. Ward" wrote:

> You can use the following TSQL statement to identify the TraceID of any
> Traces that are currently running:
>
> SELECT DISTINCT traceid FROM :: fn_trace_getinfo(default)
>
> You can then stop any running traces by setting the status of the TraceID to
> stopped (0).
>
> ie.
>
> EXEC sp_trace_setstatus @traceid = 1,
>  @status = 0
>
> HTH
>
>
> - Peter Ward
> WARDY IT Solutions
>
>
> "Andre Gibson" wrote:
>
> > I stsrted a trace on one of my bds and it is creating mulitple 5 mb files. I
> > thought it would stop once I closed the profiler. WRONG!!!
> >
> > How can I stop this?