September 3, 2003 at 3:04 pm
I want to see what tables got affected when a front end app run through data entry process. How should this be achieved by sql script or stored procedure?
Thanks
steve yang
steve yang
September 3, 2003 at 4:47 pm
I would use SQL Profiler. If the front-end app is running by itself, then simply trace everything, otherwise you may need some filtering to isolate that app's actions from other activities.
Cheers,
- Mark
Cheers,
- Mark
September 4, 2003 at 9:53 am
Profiler is really the only way out of the box. Lumigent has a product called Entegra that I believe can help as well.
Steve Jones
September 5, 2003 at 8:07 am
Thank you all for the help.
steve yang
steve yang
September 5, 2003 at 10:24 am
You can also download a free tool called SchemaAlert from Lumigent, which will log any object changes to Windows application event log.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply