Re: Audit Trace Files

Munish
I'm affraid you cannot. Once trace is stopped SQL Server does not keep any
info about it



"Munish Narula" <munish.narula@xxxxxxxxx> wrote in message
news:07439C49-276C-4677-B975-0341882D2C0F@xxxxxxxxxxxxxxxx
Hi,
Thanks for the response.

But this again does not solve my problem. The sys.traces catalog view
contains the current running traces on the system. This view is intended
as a
replacement for the fn_trace_getinfo function.

I want to get all the trace files that have been created so far.





"Uri Dimant" wrote:

Hi
In SQL Server 2005 take a look at sys.traces system table





"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?





.

Relevant Pages

  • Re: Question on C2 Log
    ... I am now analyzing the trace, ... >> auditing all logins no matter it is successfully or failed? ... >> Audit Level you wanted. ... click SQL Server and Windows. ...
    (microsoft.public.sqlserver.security)
  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • Re: Profiler Security
    ... There's no way to restrict what a user of trace can see - if they ... etc. coming into SQL Server. ... >> want to assign the developers the sys admin sql role. ...
    (microsoft.public.sqlserver.security)
  • RE: Traces for Upgrade Advisor Tool SQL Server 2005?
    ... In SQL Server 2005, global trace flags set by a session take effect in other ... SQL Server 2005 introduces global and session level trace flags. ...
    (microsoft.public.sqlserver.tools)
  • Re: One Web Service updates SQL, another cant?
    ... Columnist, SQL Server Professional ... I guess its because this is my first Web Service and I ... it opens the database connection. ... See what that gives you in the trace. ...
    (microsoft.public.sqlserver.security)