One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change ... delete statement then CDC is for you. For instance, you can use CDC in your incremental ...