Friday, October 30, 2009

Database Design and Audit

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.