General discussion

  • Creator
    Topic
  • #2277691

    Logging and reporting record changes – help please

    Locked

    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.

All Comments