Re: trace Id for C2 audit


Just to add to Erland's comment, that trace is known as the default trace
and usually has traceid = 1 (There is also a blackbox trace but it is not
enabled by default).

What it is interesting is that if I enable C2 for testing, C2 uses the
traceid = 1 and the default trace now becomes traceid = 2.

Hope this helps,

Ben Nevarez
Senior Database Administrator
AIG SunAmerica



"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: 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: Audit stored procedures
    ... Rather than using Profiler, use a server-side trace instead. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • RE: cannot delete a record in sql server 2005 through asp program
    ... Using trace script he provided and trace file created by the script. ... SQL Server database by the asp application. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.programming)
  • 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: Auditing sql server at runtime
    ... SQL Server native tools don't do any port sniffing. ... Use SQL Profiler to define your trace, ... Create a SQL Agent job to run that trace, paste the script into it. ...
    (microsoft.public.sqlserver.clients)