Join or sign in Register for your free TechRepublic membership or if you are already a member, sign in using your preferred method below. Use Your Email Use FacebookUse Linkedin

Logging and reporting record changes – help please

Locked

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.

Topic