General discussion
July 19, 2006 at 08:24 AM
paulhenriques

Auditing changes in all SQL tables

by paulhenriques . Updated 20 years, 2 months ago

I have an application that we purchased that accesses it’s database in SQL Server 2000. I wanted to know what tables the application accesses when a certain function is performed.

I thought that I could add a trigger to each table that would insert a flag into a new table but there are almost 700 tables in the database and this would take forever to do.

Is there something else I can do to identify what tables are updated/inserted when I perform a function in an application?

Any help is much appreciated.

Paul.

This discussion is locked

All Comments