Built a Universal Auditing System Using Dynamic SQL

Situation

The platform lacked a consistent way to track changes across client databases. Each client schema was different and writing custom audit logic for each was impractical at scale — but legal discovery clients had strict requirements for audit trails.

What I Did

Designed and built an auditing system using triggers and dynamic SQL to automatically track changes to any SQL Server 2000/2005 database. The system required no schema-specific customization — it interrogated the schema at runtime and generated the appropriate capture logic dynamically.

Result

Tools & Tech