Re: trace Id for C2 audit

What i is observed is that "blackbox" trace is moving to traceid 2 when C2
trace is enabled which get traceid 1 and both the traces are active.

"Erland Sommarskog" wrote:

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

SQL 2005 has a "blackbox trace" enabled by default with trace id = 1. But
I don't know whether that trace is disabled if you turn on C2.



--
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: SP_Trace_create
    ... blackbox trace status. ... -- If @on is zero then stop and delete the blackbox trace. ... declare @traceid int, ... exec sp_trace_setstatus @traceid, 2 -- delete blackbox trace definition ...
    (microsoft.public.sqlserver.tools)
  • Re: Converting Traceid issue
    ... The job executes the stored procedure to start the trace and every 15 ... DECLARE @traceid int ... SQL Server, the string literal is converted to sql_variant. ...
    (comp.databases.ms-sqlserver)
  • Re: Problem using SP_TRACE_SETFILTER - it doesnt seem to apply th
    ... The problem is I am attempteing to Filter on duration> ... production environment and capture everything, I strongly suspect that I will ... where @TraceId was the @TraceID variable used to assign the traces in the ... ::fn_trace_getinfo ALL return data about the trace I had just created! ...
    (microsoft.public.sqlserver.server)
  • Re: How do I know if a TRACE is active in a SP?
    ... an active TRACE is passed to the call SPL. ... > the top SP's have already activated a trace, else if the bottom one ... it overwrite the existing one. ...
    (comp.databases.informix)
  • Re: Converting Traceid issue
    ... I needed to use CAST instead of ... CONVERT for the traceid to get it to read as an INT. ... The job executes the stored procedure to start the trace and every 15 ...
    (comp.databases.ms-sqlserver)