Michael Whiteley (7/8/2009)
If only using SQL 2008 I would use Change Data Capture it does it all for you.
Unfortunately, Change data capture is available only on the Enterprise, Developer, and Evaluation editions of SQL Server. E.g. if company has 4-5 production servers with 4 processors each the price between Standard and Enterprise edition is prohibit to use this feature.