AutoAudit 1.09 posted to CodePlex

hello, after testing AutoAudit 1.09, I had a little problem. The "ALTER_TABLE" Schema of the trigger, is not activated when you change a table in design. We assume that as you use a temporary table does not exist and the real can not find it. Any solution? Thanks in advance

Tested this code quite extensively and found a couple of bugs.

The RowHistory does not like it when the initial row has NULL field values for the first version. The COALESCE which is used to detect whether there is a row and if not use the actual current field value is also picking up the initial NULL field value and returning the current value.  As a result, the initial row is incorrect in the history.

I've corrected this by using a SELECT CASE WHEN EXISTS instead, first checking to see if the row exists and if so using the OldValue regardless. If the row does not exist, use the actual value.

The second I'm not sure whether it is a bug or not, but when you delete a record and query the RowHistory, the initial record disappears giving you no indication of what the row originally looked like.  I'm working on a fix for this at present as I'd really like this feature.