Using Triggers to Track Database Action History

By Bill Graziano on 18 September 2001 | Tags: Stored Procedures

Several State and Federal contracts that I have worked on in the past have wanted to keep track of all changes to a particular record, such as who modified the record, what kind of modification took place, and when the record modification occurred. I decided to solve this problem with triggers because I wanted to capture every action that occurred on a particular table.

Link: Using Triggers to Track Database Action History