Where are these .trc files coming from?? 1

[unclerico]

Windows 2000 Server SP4
SQL Server 2000 SP3a


At one point in the past someone here must have created a new trace and not ended it. I have looked through all of the jobs within SQL Server as well as within Windows and I cannot find out what the heck this trace is called so that I can kill it, it is generating a crap load of .trc files that are chewing up disk space. The .trc files are named audittrace_datetime_sequencenumber.trc...does anyone know how I can find out the TraceId?? Thanks.

 

[unclerico]

anyone?? I promise that I'll give you 9 stars for your help.

 

[SQLDenis]

when you run sp_who2 from query analyzer do you see SQL Profiler anywhere in the ProgramName field

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[MDXer]

First run the following code to get the traceid

SELECT *
FROM ::fn_trace_getinfo(default)

Once you have identified the traceid you then run the follwoing to stop the trace

sp_trace_setstatus @traceid = <<your traceID>>,
                   @status = 0

If you then want to delete the trace run the follwoing

sp_trace_setstatus @traceid = <<your traceID>>,
                   @status = 2

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[unclerico]

mdxer you da man, thanks a lot for the tip, works like a charm. sqlDenis, I promise that you can answer my next question ;-)