Take some example that some data base updations will be done through one of your screen in the project. To know what are the Sql server tables will be effected when doing some thing in that screen…………………….
Make sure that dabase will be on local machine….
Open Sql Profiler of Sql Server……………….
Go File –> New –> Trace
Then Trace Properties screen will appears and asks to give trace name. Give what ever name you like..
Click Run Button….
Now go for your project screen and click any button which will update or modify database. All the transactions will be loaded in the Trace of sql profiler.
means what are the queries executed when you clicked that button , which stored procedures executed………etc….
Gives a sample view that what are the tables effected when click a button of a screen in the project.
