• If only using SQL 2008 I would use Change Data Capture it does it all for you.