RE: auditing database/server activities

From: dwh2200 (dwh2200_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Tue, 28 Sep 2004 10:35:07 -0700

I'm currently using a sql profiler trace to track changes made on the
database. Not really tracking inserts/updates/deletes, just the DDL and
security stuff. The Security Audit group of events in profiler give you most
of what you'd be interested in. For digging through transaction logs,
Lumigent's Log Explorer isn't a bad tool. For some extra $$, Entegra might
be an option as well.

"jason" wrote:

> with increased concern of security these days. what are people using to
> audit the activities on a sql server database?
>
> if they use in the box tools, is the audit trail managable?
>
> are people using a 3rd party tool to do sql server auditing?
>
> thanks

Relevant Pages