Where are these .trc files coming from?? 1

unclerico · Mar 1, 2006

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 · Mar 2, 2006

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

SQLDenis · Mar 2, 2006

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 · Mar 2, 2006

First run the following code to get the traceid

Code:

SELECT *
FROM ::fn_trace_getinfo(default)

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

Code:

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

If you then want to delete the trace run the follwoing

Code:

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

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

unclerico · Mar 2, 2006

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Where are these .trc files coming from?? 1

unclerico

IS-IT--Management

unclerico

IS-IT--Management

SQLDenis

Programmer

MDXer

Technical User

unclerico

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor