Re: Audit Trace Files
- From: "Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 28 Dec 2007 07:00:42 -0600
You can get the file path only for active and stopped traces. As Erland and Uri mentioned, no record is kept after the trace is deleted.
It's not hard to develop a process to manage trace files, though. For example, I have a daily SSIS package that restarts a trace and copies the files to an archive folder.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Munish Narula" <munish.narula@xxxxxxxxx> wrote in message news:4412799B-EE0B-431B-92E2-F51988471166@xxxxxxxxxxxxxxxx
I am using server side traces to enable SQL Server 2000 and 2005 auditing.
Every time I start the server, I define a new trace file for auditing. So
till now I have configured around 100 trace files.
Now I want to get the list of all the trace files (which are at different
location in my PC), using some mechanism. Please let me know if there is a
function or procedure which will give me all the trace files that have been
configured for auditing in SQL 2000 and 2005.
I found a function fn_trace_getinfo, which returns information about a
specified trace or all existing traces, but I want all the trace files, which
have been created till now, irrespective of whether they are active or not.
Is there a function in SQL which would help me in this?
.
- Prev by Date: Re: Cannot connect with the Administator account
- Next by Date: Re: SQL Local Account Permission - Read Only on System Tables and View
- Previous by thread: Re: Audit Trace Files
- Next by thread: Re: trace Id for C2 audit
- Index(es):
Relevant Pages
|
|
