Audit tools for MS SQL Server

I'm trying to gather a list of Audit Tools (for auditing data changes not for
security audit). So far, I have gathered this:
Upsence Productions - MSSQL Log Manager
Lumigent - Entegra for SQL Server
Krell Software - OmniAudit
Apex SQL Software - Apex SQL Audit
Are there any other one?
Thanks.
Hello Peter,
You might also check LogPI...
-Kevin Kline
Quest Software (www.quest.com)
SQL Server MVP
I support PASS, the Professional Association for SQL Server. (www.sqlpass.org)

> I'm trying to gather a list of Audit Tools (for auditing data changes
> not for security audit). So far, I have gathered this:
> Upsence Productions - MSSQL Log Manager
> Lumigent - Entegra for SQL Server
> Krell Software - OmniAudit
> Apex SQL Software - Apex SQL Audit
> Are there any other one?
> Thanks.
>

Audit table/index access

I inherited a rudimentary data warehouse and would like to gather data on
which tables and which indexes are being used. Queries to the warehouse are
typically issued via ODBC from an ACC2003 front-end.
I have chosen SQL profiler as the tool to identify object usage. I thought
ObjectOpened would provide information on access to tables and indexes,
however, using that (and only that) event produces no results. I have
stripped away all filters.
I initiate a select in query manager, the select returns results. The
profiler session logs no ObjectOpened events. It will log SQL:Statement
started.
Questions:
1) is this the correct tool to use to identify which tables and indexes are
being accessed?
2) am I using the correct event?
3) why no results
Thanks all
======================
JG
Systems/DBA Supervisor
Vermont Agency of Transportation
GIAC Security Certified
MCSE, CCNA
See if this article helps you:
http://www.sql-server-performance.co...on_english.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Vihrea" <Vihrea@.discussions.microsoft.com> wrote in message
news:5562075F-C49C-4D94-9473-3E06EC82E965@.microsoft.com...
> I inherited a rudimentary data warehouse and would like to gather data on
> which tables and which indexes are being used. Queries to the warehouse
are
> typically issued via ODBC from an ACC2003 front-end.
> I have chosen SQL profiler as the tool to identify object usage. I thought
> ObjectOpened would provide information on access to tables and indexes,
> however, using that (and only that) event produces no results. I have
> stripped away all filters.
> I initiate a select in query manager, the select returns results. The
> profiler session logs no ObjectOpened events. It will log SQL:Statement
> started.
> Questions:
> 1) is this the correct tool to use to identify which tables and indexes
are
> being accessed?
> 2) am I using the correct event?
> 3) why no results
> Thanks all
> --
> ======================
> JG
> Systems/DBA Supervisor
> Vermont Agency of Transportation
> GIAC Security Certified
> MCSE, CCNA
>

Audit table/index access

I inherited a rudimentary data warehouse and would like to gather data on
which tables and which indexes are being used. Queries to the warehouse are
typically issued via ODBC from an ACC2003 front-end.
I have chosen SQL profiler as the tool to identify object usage. I thought
ObjectOpened would provide information on access to tables and indexes,
however, using that (and only that) event produces no results. I have
stripped away all filters.
I initiate a select in query manager, the select returns results. The
profiler session logs no ObjectOpened events. It will log SQL:Statement
started.
Questions:
1) is this the correct tool to use to identify which tables and indexes are
being accessed?
2) am I using the correct event?
3) why no results
Thanks all
--
======================
JG
Systems/DBA Supervisor
Vermont Agency of Transportation
GIAC Security Certified
MCSE, CCNASee if this article helps you:
http://www.sql-server-performance.c...ion_english.asp
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Vihrea" <Vihrea@.discussions.microsoft.com> wrote in message
news:5562075F-C49C-4D94-9473-3E06EC82E965@.microsoft.com...
> I inherited a rudimentary data warehouse and would like to gather data on
> which tables and which indexes are being used. Queries to the warehouse
are
> typically issued via ODBC from an ACC2003 front-end.
> I have chosen SQL profiler as the tool to identify object usage. I thought
> ObjectOpened would provide information on access to tables and indexes,
> however, using that (and only that) event produces no results. I have
> stripped away all filters.
> I initiate a select in query manager, the select returns results. The
> profiler session logs no ObjectOpened events. It will log SQL:Statement
> started.
> Questions:
> 1) is this the correct tool to use to identify which tables and indexes
are
> being accessed?
> 2) am I using the correct event?
> 3) why no results
> Thanks all
> --
> ======================
> JG
> Systems/DBA Supervisor
> Vermont Agency of Transportation
> GIAC Security Certified
> MCSE, CCNA
>