One of the interesting new features in SQL Server 2008 is Change Data Capture ... If you need to know the column data involved in an insert, update or delete statement then CDC is for you.