Here is an article on The Code Project about how to use CodeSmith to generate audit log triggers for your database.
http://www.codeproject.com/database/AuditTriggers.asp
No Comments