When developing ASP.NET application that use a APP Pool and identity to make all calls to the back end database in order to have a trigger based solution for auditing.
I would recommend all your tables have updatedDT and updateBY columns in all the tables you want to audit.
