Hi,
I am trying to create a data dictionary for a huge application which has aroung 300 tables in the database....when i perform any operation in the application some tables are updated.... can you help me to find out how can we find out the last updated tables in the database ?
Try using SQL Profiler to monitor which tables are being updated.
You can also search for SQL Dependency Analyzer - there are a few tools out there that will track this.
cheers,
Andrew
