I have a Database in which I have to create a ChangeLog.
Temporarely I add a New Record manually at the end of any change in the Application. Now I whish to change this to Triggers.
In The Changelog I have to record the following infrmation:
Date of the Change
Time of the Change
User who eperformed the Change
Table in which the Change was done
The ID of the changed Record
A Detailed Description of the change
At this time the code works very well to write these thing to the ChangeLog. But when somebody have to change or extend the Application he has to think about the ChangeLog and add the extra code.
I never looked at the Trigger feature. The Documentation in the Book Online is not enough for me to achieve what I need.
Can somebody help me, please?
Any help will be appreciated.