CodeSmith Generated Audit Log Triggers

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