The way I have seen for the issue of which table is to introduce a view and setup triggers on the view to run a stored proc when you insert or update it to hand

The way I have seen for the issue of which table is to introduce a view and setup triggers on the view to run a stored proc when you insert or update it to handle all the tables....