sql - How to find all the tables impacted during a certain amount of time -


my task documenting happens in sql server database when user click button. "something" pretty complicated , impacts (with insert/update/delete) 50+ tables.

i'd see happens table per table don't have practical way know table check. if use profiler terribly long list of stored procedures names, not single statements. there practical way can find out tables changed in content, using profiler or other tool, script or tecnique? maybe there's system table keeps track of last date each table received insert/update/delete?

i though best way search on google not wanted how that. , found following:

http://blog.sqlauthority.com/2009/05/09/sql-server-find-last-date-time-updated-for-any-table/

here can list last time table changed check time, press "the button" , run query filter "date last change" > time_i_read_before_pressing_button.


Comments