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 |
|
Jonny1409
Posting Yak Master
133 Posts |
 Posted - 2008-01-21 : 11:11:31
|
| Hello,I'm currently having a problem with my db in as much as the values in certain fields are changing.I don't believe they are being changed by the application (although I can't be 100% sure)However, I'm looking for a way of putting some sort of trigger on a table, whereby if someone makes a change the that table, it will populate a notes field in another table advising who they are, what field they have changed etc.Is this possible ?If so, where would I start ?Thanks. |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2008-01-21 : 11:32:47
|
| Have a look at this topic:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210Specifically at this section:Triggers Triggers to audit changestrigger to keep tables matchingSet Update/Modified date column using a trigger 02Nov2005Be One with the OptimizerTG |
 |
|
|
Jonny1409
Posting Yak Master
133 Posts |
Posted - 2008-01-22 : 10:47:11
|
| Thanks TG, I'll look into that - it looks like it will be what I need. |
|
|
|
|
|
|
Logging / Tracking Help Please