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...

This post is related to this tip: 10 Steps Checklist: Re-Architecting a SQL Server Backend System http://www.mssqltips.com/tip.asp?tip=1403