Hi guys,

I have been allocated to a new completed project for maintenance work and i don't know the tables our application is hitting. There are few static master tables and few dynamic tables where data are consistently coming from customer (client side) and are hitting few tables. I want to know the way i can see those tables where data are hitting. i mean, suppose 10 customers are entering data (a transaction) into 3 tables. Now, how do i see those 3 tables where data are getting entered.


Kindly provide me a solution, it's very urgent.

Thanks a lot.

You may use SQL Server Profiler tool. There you have the option to filter the results by Application Name.
How to: Filter Events in a Trace (SQL Server Profiler)