SQLTeam.com Logo

Return to Using Triggers to Track Database Action History

Using Triggers to Track Database Action History

Written by Bill Graziano on 18 September 2001

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.