IT Employment

General discussion


Logging and reporting record changes - help please

By colingbradley ·
One of my clients needs to be able to run a report at the end of each month of changes to several key tables within a SQL database.
The application (Scala business systems) does not provide the functionality, so I am looking for the best way to do this.
My first choice is to use the SQl tools if possible, I don't know where to start and am open to any hints and suggestions.
This is all part of the new reporting rules as a result of the Enron disaster.

20th Sept 04
I have found out that Manage Triggers is a built-in method. You need to create tables to hold the data and then use the Manage Trigger script to populate the new table with selected fields and the date/time and User ID.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums