Re: Audit Trace Files

Munish Narula (munish.narula@xxxxxxxxx) writes:
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?

I don't think so. As I understand it, once a trace is done, SQL Server
forgets all about it.



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: best practice analyzer help
    ... you're feeding to BPA. ... Trace files should be files generated by SQL Server ... > the log file cannot be found anywhere on the server or in my pc that I run> it from... ...
    (microsoft.public.sqlserver.tools)
  • Re: ora817 sga problem
    ... Do you have any trace files in the udump folder on the server? ... Maybe your shared pool is too small or too fragmented, of course flushing it helps at that time, but only for some time ... ...
    (comp.databases.oracle.server)
  • Re: problems w/ fn_trace_gettable
    ... The trace files are located on the server running the SQL ... >Can you show us the exact command you are using? ...
    (microsoft.public.sqlserver.server)
  • Re: problems w/ fn_trace_gettable
    ... E:\ is local to the server. ... UNC instead. ... >Andrew J. Kelly SQL MVP ... >> The trace files are located on the server running the ...
    (microsoft.public.sqlserver.server)
  • Re: Audit Trace Files
    ... In SQL Server 2005 take a look at sys.traces system table ... Every time I start the server, I define a new trace file for auditing. ... Now I want to get the list of all the trace files (which are at different ...
    (microsoft.public.sqlserver.security)