I've found a major bug in the
most distributed audit trigger code for SQL server. I've seen this code in many places but one(!) table (on my local machine) wasn't writing any changes to the audit table. So I've investigated ( for a few hours) and found that the bits operation with
COLUMNS_UPDATED()
wasn't right. In fact MSDN says that we should not rely on ORDINAL NUMBER of a column but the COLUMN_ID.