Re: trace Id for C2 audit

Although the C2 trace id currently returns 1, I wouldn't rely on this behavior. Out of curiosity, why do you care what the trace_id is?

--
Happy Holidays,

Dan Guzman
SQL Server MVP

"Munish Narula" <munish.narula@xxxxxxxxx> wrote in message news:CDF07A0D-6847-498E-9098-3FDA10374749@xxxxxxxxxxxxxxxx
Is it a fair assumption to make, that the traceId of c2 auditing is always 1?

Say, I have switched on C2 audit in SQL 2000 and 2005 and i use
fn_trace_getinfo to get the active trace. Will it always return me traceId
as 1?

.

Relevant Pages

  • Re: Setting up Trace in SQL
    ... > The company has a policy and states that we have to audit> our databases. ... >>SQL Server MVP ... But supposed if I were to re-start the DB, the>>> audit does not kick off at all coz the trace files still ...
    (microsoft.public.sqlserver.security)
  • Re: SQL profiler question
    ... description doesn't seem to load into the table when I run the trace directly ... > Tibor Karaszi, SQL Server MVP ... >> is not a recognizable trace file. ... >>> Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL profiler question
    ... Tibor Karaszi, SQL Server MVP ... I created the trace to load a file. ...
    (microsoft.public.sqlserver.tools)
  • Re: Using Profiler to filter update statements on a database table
    ... You need to use the right events in the trace. ... Tibor Karaszi, SQL Server MVP ... "TMR" wrote in message ...
    (microsoft.public.sqlserver.tools)
  • Re: trace file created but not populated
    ... The trace is kept in memory until it has reached a certain size (128 KB if I ... SQL Server MVP ... >I created the trace in profiler and it runs ok in the profiler. ...
    (microsoft.public.sqlserver.server)