I recently ran into a situation where an existing application was deprecated and replaced. The tables associated with this legacy application should have gone cold... but they didn't so it was my job to figure out how.
Full disclaimer, this is obviously not an end all method to track down rogue updates for a table, but it can be helpful. I created this simple script which looks at index stats for the table(s) in question and finds the most recent update time(which you can add a filter date for). Then we just find dependent stored procedures and triggers for the table(s) and display their last execution time.
The results give you a very good idea where to start looking with minimal effort.
-Matt
Kommentare