Add auto-incrementing IDENTITY column to AUDITLOG (2 replies)
A really good idea. I need to delete old audit log entries through SQL management studio and in many cases I can't delete them because there are multiple records with the same key and SQL gives the error such as "the row value(s) updated or deleted do not make the row unique or they alter multiple rows".
Closed due to inactivity.
There is no way to determine which row is added first when two rows have the same timestamp. Could you add an auto-incrementing IDENTITY column?