Re: SOX audit tool

From: Derrick Leggett (derrickleggett_at_yahoo.com)
Date: 10/17/04


Date: Sat, 16 Oct 2004 17:53:15 -0500

You can use NOT IN on the HostName filter to filter out any of your
applications servers or the SQL Servers. You can then have a report query
that looks for Access or Excel in the ApplicationName. Use Profiler or a
standard trace for this.

"Hong Wang" <HongWang@discussions.microsoft.com> wrote in message
news:5EDD643E-F7FB-4F16-A437-FEFDFAD85815@microsoft.com...
> Hi,
>
> Our company is currently performing a SOX audit on all of databases. Is
> there any monitor tool for SOX audit for SQL Server database? We are
> specifically looking for tool that can tell info like somebody is
accessing
> the database through Excel or Access via a PC workstation instead of
thorugh
> application front end.
>
> Thanks.