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.