The requirement was to log changes to columns on any table
to a common table. The information to be recorded was Table Name, Column Name,
Action (Deletion, Insertion, and Modification), Old Value, New Value, Modified
User, Modified Time and Modified PC.
The solution I came up with is to create the triggers on
table using a script that trigger that fires on Update Delete and Insert. This
trigger sends the information to a function that checks for changes. In the function
if there are changes it will be logged to the Audit table. When calling the
function I checked for the ‘Action’ and according to that change the
information send to it.