July 19, 2005 10:19 PM
Auditing Advice
Try these tricks for designing audit triggers
Rating:
(0)
SQL Server Magazine
InstantDoc ID #46713
When you need to audit data changes, you face several challenges. The course of audit action you take might depend on the number of affected rows, the type of statement that modified the data, and whether you want to audit both successful events and failed events. Also, you might want to audit each attribute value change in a separate audit row. Dealing with such auditing issues can be tricky, and as you'll see later, you need to apply logic to come up with solutions. We'll look at a strategy fo...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: