C2 auditing on SQL Server

From: RS (rspen_at_yahoo.com)
Date: 03/16/04

Date: Tue, 16 Mar 2004 08:53:24 -0600

I currently have C2 auditing turned on for a server, and an audit trace file
gets written to the default database directory every couple of hours. Is
there a way to get C2 auditing to write to a separate database for querying?

And is there also a way to turn C2 on/off without restarting the server?

Is C2 the appropriate tool for internal auditing, or is there a
better tool out there for getting reports, etc?

cross posted to .securitytools