sqlSpy will monitor and record activity in your sql server databases. It has a ton of other really cool features for monitoring ie. # of users...
Without knowing your design constraints another option that may work for you would be to dump all your source data into the same destination table...
Zero! It's a hardware problem! [:D]
If you're talking about auditing by DDL yes, it on the RCO release. This is from the mssql 2008 Product Information Overview about new features for...
Check out Apex's SQL Diff tool also
Separate names with a comma.