SQL - How to revers engineering to discover the source of the data

tommym121
tommym121 used Ask the Experts™
on
I am working on a data migration project.   I have been successfully migrated most of the information from a database (SQL server 2008) by using a front-side database client application.  However there is few fields on the front-side database client application that I am not sure the corresponding columns of a table.
Is there any way to discover which columns or tables that are touched when I try to update a record from the front-end database client application
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
The Sql Service Profiler (under Sql Service 2008 - Performance Tools ) gives you options to trace activity.

It is very helpful if you specify filters to prevent getting volumes of trace logs.

Author

Commented:
thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial