Re: SQL SOX audit and logging

Thank you Sue.

I think I will review the Idera software. That might be the best solution
for the SOX team. They can have control over it and not the DBA.

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:9r7ls2phuhvt07uqq1i6ue5do2mplek7mq@xxxxxxxxxx
If you wanted a third party tool, I've used Compliance
Manager from Idera a couple of times for SOX compliance:
http://www.idera.com/Products/SQLcm/Default.aspx

-Sue

On 7 Feb 2007 10:14:46 -0800, "Maninder"
<msdhanjal@xxxxxxxxx> wrote:

Turn on C2 Auditing for all Logging.
Also you can write Queries based on system tables and Store the data
in a table.
Create Trigger at server scope for Logging.

Maninder
MCDBA



.