Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SalvaCa
Starting Member
2 Posts |
 Posted - 2006-02-03 : 05:51:15
|
Hi 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. Cheers Salvatore MCSE Germany |
|
|
Kristen
Test
22859 Posts |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-02-03 : 08:32:54
|
| Have a look athttp://www.nigelrivett.net/#Triggers==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
SalvaCa
Starting Member
2 Posts |
Posted - 2006-02-03 : 10:18:15
|
| Great.These Link looks very good. Since i never worked with Triggers I have to dive in the topic for a little time.Thank you for the help.CheersSalvatore |
|
|
|
|
|
|
Running a ChangeLog with Triggers