Maintain History of changes

[olibh]

Hi,

I'm new to SQL Server (ver 7)and would appreciate any help with the following - I wanted to capture every action that occurred on a particular table, such as who modified the record, what kind of modification took place, and when the record modification occurred. What is the best way to go about this.

 

[bperry]

This is almost always accomplished by using triggers. These are basically specialized stored procedures that are invoked automatically whenever specified actions - Update, Insert, Delete - are done on table. Within the trigger, you write t-sql code to do whatever you want - like writing out a new record to an audit file that records the changes.

You can write your own trigger(s), esp for a straight-forward situation like this.; if you had a whole ton of them to do, though, there are 3rd-party products available to help construct/maintain the appropriate triggers on a whole bunch of tables.