Re: can we change the file size that c2 creates a new trc file at ?

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 06/23/05 

Date: Thu, 23 Jun 2005 08:53:08 +0530

Hi,

As far as I know we cant change the trace file size after enabling C2 audit.

Thanks
Hari
SQL Server MVP

"Simo Sentissi" <msentissi@rightnow.com> wrote in message
news:eSKK8R3dFHA.688@TK2MSFTNGP14.phx.gbl...
> hello there
>
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
>
> any ideas ?
>
>

Relevant Pages

  • 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: Setting up Trace in SQL
    ... from the designated directory. ... >> I have configured SQL Server to activate a trace at ... The main objective is to audit all ... >> trace file 'TraceA.trc' already exists in the directory. ...
    (microsoft.public.sqlserver.security)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Return Key (identity) on INSERT operation (SQL/ASP)
    ... hopefully he can expedite processing your full subscription. ... SQL Server MVP ... Columnist, SQL Server Professional ... Please reply to the newsgroup. ...
    (microsoft.public.sqlserver.programming)
  • Re: One Web Service updates SQL, another cant?
    ... In the profiler, in the Events tab, click on Security Audit. ... Columnist, SQL Server Professional ... And then I start getting the database closed errors on subsequent calls. ... >>> thing to look at is the permissions for that user in EM. ...
    (microsoft.public.sqlserver.security)
Loading