Logging and reporting record changes – help pleaseLocked
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.