I'm testing the Audit functionality in SQLServer 2008 Enterprise, but it looks like the data that's stored for an update doesn't include the value of the column before and after the operation.
This is pretty fundamental to my audit requirements.
For example, I've set up Auditing on my Customers table and when I make an update to a row using something like
UPDATE Customers SET MaritalStatus = 1 WHERE CustomerID = 555
The audit data says that I made the change and when I made it, but doesn't say what row was affected, what data was changed and what it was changed to.
At first glance, it looked like the perfect solution, but now looks useless.
Have I missed something?