An audit trail is needed for various reasons. Some companies need it for compliance, others need it to find out who “accidently” did something stupid last week, and some specialized audit trails can tell you how the data has changed over time.
So, it is time to follow Dorothy and Toto down the yellow brick road and to share your experience with auditing data. If you are new to the T-SQL Tuesday blog party and need some ideas, here are a few:
- How to implement SQL Server Audit which was introduced in SQL 2008.
- Your favorite audit pattern.
- Your worst experience with an implementation of a bad auditing pattern.