Re: can I send the audit file to a table?

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 09/28/04


Date: Tue, 28 Sep 2004 14:41:29 -0600

You can't have the traces go directly to a table but you can use the
fn_trace_gettable function to load the trace files into a table. Refer
to books online for more information on fn_trace_gettable.

-Sue

On Tue, 28 Sep 2004 13:13:06 -0700, "M" <M@discussions.microsoft.com>
wrote:

>Hi,
> I have "C2 audit mode"=1, is it possible to send the trace files to a
>table?, how can I do it ?



Relevant Pages

  • Re: Replay Trace Profiler files with T-SQL code
    ... Replaying trace files is a function of the SQL Profiler application, ... Even with SQL Profiler replaying the script they may not be executed in the same time scales as the original load. ... Just using T-SQL is never going to give you the means to re-create a true load; even the load testing tools available will not give you an exact replay, but will give you a means of stressing the system, and a method which is more likely to re-create the situation where problems will occur ...
    (microsoft.public.sqlserver.programming)
  • Re: Replay Trace Profiler files with T-SQL code
    ... Replaying trace files is a function of the SQL Profiler application, ... available on the file menu of SQL profiler and run the script it creates. ... but how much of relastic load is when you run it as ...
    (microsoft.public.sqlserver.programming)