Walter, again, thanks for everything you've contributed on this. Even if we don't agree, it gives people information when they have only have one option.

Next question - suppose you want to get immediate feedback on what was changed on a database row. An UPDATE occurs, and you want a snapshot of the row before the UPDATE occured, and then after the UPDATE occured. (including any calculated columns, or columns affected by a trigger, etc.)

So just as a simple test....suppose you issue an UPDATE statement and it affects an invoice header row (InvoiceHeader), and five invoice detail rows (InvoiceDetail). The UPDATE might include triggers or other processes that update the data.

You want a snapshot of the "before" and "after" for the invoice header row and the five detail rows.

How would you do it? I'm essentially taking the SQL Server 2005 stored proc side, you can take whatever side you want.

Thanks,
Kevin