Re: SOX audit tool
From: Derrick Leggett (derrickleggett_at_yahoo.com)
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
> 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
> the database through Excel or Access via a PC workstation instead of
> application front end.