Are there tools available for auditing changes to SQL Server data?
Sometimes you just can’t explain how certain data gets in your database, or how it arrives at a certain state. Wouldn’t it be nice to be able to track which user affected which data, and when they did it? SQL Server Profiler will certainly allow you to log all DML operations. In high-volume systems, of course, this is just not feasible — your data can change so often, that you would need more disk space for the audit trail, than for the data itself!
Related Questions
- I have phone/directory administration tools for the moves, add & changes in my organization. Can I import its data to automate/simplify system entries?
- I want to use Merge Replication to synchronise data to my SQL Server CE database. Are there any how-to whitepapers available?
- Are there tools available for auditing changes to SQL Server data?
