Re: C2 SQL auditing

Hi Andrew,

I had to setup C2 for my company just so they can see it in their own eyes.
I recommended them to use Server Side trace, it is more efficiency and
customizable to what they want to audit.
It would make my case even better when I tell them 3 SQL MVPs suggest not to
use C2.

Do you suggest any third party tools for SOX compliance? I am testing Idera
CM right now.
Eventually, I would like to off load the server side trace to the SOX team
since there are over 100 SQL Servers.
I would like to setup and manage so many traces.

Thanks again for the input...I greatly appreciated.

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OqOIdLiVHHA.3592@xxxxxxxxxxxxxxxxxxxxxxx
Don't use the C2 auditing. Just create a custom trace that collects the
data
you want and you can start and stop it as you need to. Check out
sp_trace_Create in BooksOnLine.

--
Andrew J. Kelly SQL MVP

"SQL apprentice" <mssqlworld@xxxxxxxxx> wrote in message
news:OYlONfeVHHA.3500@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!






.

Relevant Pages

  • Re: Running profiler on busy 8-cpu Sql Server
    ... I always start with a light trace and add more detail as I go along to ... SQL Server MVP ... > I think it's also worth saying that you should introduce Profiler ... > SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT deadlock question
    ... > Profiler to view a trace, SQL Server dumps rowsets across the network to ... > SQL Server doesn't feel like it can keep up with all the activity. ... > server-side trace to a trace file guarantees you'll see everything. ...
    (microsoft.public.sqlserver.server)
  • Re: URGENT deadlock question
    ... >> network to the Profiler client, but there is no guarantee you'll see ... >> everything if SQL Server doesn't feel like it can keep up with all ... Just make sure the trace file is created on a local ...
    (microsoft.public.sqlserver.server)
  • web-enable application for SQL Server 2000 MS Access 2000 front-end
    ... Current setup is an SQL Server ... everything surrounding security, i.e. suitable user access, firewalls, etc. ...
    (microsoft.public.sqlserver.security)
  • Re: Install of SMS not detecting Active Directory
    ... admin on SMS server and using remote SQL server) but I had used the same ... setup runs in the context of the logged on user and not the ... >> installation fails immediately after answering the options with an error ...
    (microsoft.public.sms.setup)