"SQL apprentice" <mssqlwo***@yahoo.com> wrote in message
news:OeohZfeVHHA.1036@TK2MSFTNGP03.phx.gbl...
> 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!
>
>