http://weblogs.asp.net/jgalloway/archive/2008/01/27/adding-simple-trigger-based-auditing-to-your-sql-server-database.aspx

Hope that helps! I've used that in several applications. However, I've often customised it to be able to select the columns I want to audit because sometimes auditing all columns...