Implement Audit Trail Quickly for Microsoft SQL Server

It explains how to implement an audit trail quickly by creating shadow table for each table in database and triggers to log every time when a record is inserted, updated or deleted in the table.