Re: C2 SQL auditing

From: "Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx>
Date: Wed, 21 Feb 2007 19:51:54 +0100

See my reply in other group.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"SQL apprentice" <mssqlworld@xxxxxxxxx> wrote in message news:OeohZfeVHHA.1036@xxxxxxxxxxxxxxxxxxxxxxx

Hi,

I setup my SQL 2000 Server to use C2 auditing. It is working.
My only problem is that my trace file does not get populated while I am
inserting/updating/select data or anything.
However, when I stop SQL server then my trace file gets populated.
I cannot stop a production SQL server on and off just to collect data and
the trace file is only limited to 200MB so I can wait till the end of day.
I am trying to do a audit report every 2hrs.
Am I doing something wrong? Or this is how C2 works?

I would appreciate all the help!

References:
- C2 SQL auditing
  - From: SQL apprentice

Prev by Date: C2 SQL auditing
Next by Date: Need Help With Express Edition Tools
Previous by thread: C2 SQL auditing
Next by thread: Need Help With Express Edition Tools
Index(es):
- Date
- Thread

Relevant Pages

Re: SQL Server log file show login succeeded for use sa more than 1000 times
... I don't think it's a virus attack, since it only appears in case of client ... Meanwhile I've studied the trace file and it appears that there ... >> I also investigated the SQL Server log files and I found it very strange ... > SQL Server to Windows Only mode as a test and listen for who screams? ...
(microsoft.public.sqlserver.programming)
Re: run Profiler on a specific SP/Query/Function
... systems running on the server, for which the Application name isn't set ... Note that you don't have to have a single trace file. ... Reading about the sp_trace proceures in Books Online gives you more ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
(microsoft.public.sqlserver.tools)
Re: Setting up Trace in SQL
... SQL Server MVP ... "Audrey L" wrote in message ... > trace file 'TraceA.trc' already exists in the directory. ...
(microsoft.public.sqlserver.security)
Re: using fn_trace_gettable on trace files where the path contains a space.
... that trace file resides in a path that contains a space? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver)
Re: can we change the file size that c2 creates a new trc file at ?
... As far as I know we cant change the trace file size after enabling C2 audit. ... SQL Server MVP ...
(microsoft.public.sqlserver.security)