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: Tracing Used Tables
    ... Erland Sommarskog wrote: ... found the objects:object:Opened is not getting any trace hit. ... I am tracing with Locks->LockAquired with all the possible filter ... Tracing LockAcquired on a production server is definitely not to ...
    (microsoft.public.sqlserver.programming)
  • Re: Profiler Trace
    ... Yout trace is running ... exec sp_trace_setstatus @TraceID, 1 ... declare @TraceID int ...
    (microsoft.public.sqlserver.server)
  • 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)