MSSQLTips

Mark, Thank you for the lengthy reply and feedback. Generic tables: You are correct, only specific columns are being audited with the 2 table generic solution. The requirement is not to audit the entire row. For the population, some of the data is populated via a trigger and other data is actually populated...

MarkJo_FP, Thank you for sharing some of the challenges you are facing today with auditing. Although your new solution does have many tables it sounds like the performance is acceptable and is something you are willing to manage. How do you think a generic solution either with an XML column or a generic...