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 |
|
BenSwitzer
Yak Posting Veteran
72 Posts |
 Posted - 2004-03-15 : 08:57:23
|
| I want to be able to "log" all transactions to a few of the tables in a database in a readable format. I want to do this so that we have a history of what users did and when they did it. This is to stop some of the reports from users that insist some of their changes were not made by them. Is there an easy way to do this? I was thinking that triggers would be a good way to attempt this. Any other suggestions?Thanks.Ben Switzer |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-15 : 09:14:39
|
| You could also set up a profiler to track changes on those objects. You could write this to a table. Once you have it set up, it would be easy to add/subtract tables you want to trace from profiler.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-03-15 : 09:16:50
|
| I use Triggers to do exactly this. The great thing about a trigger is that it does not care what front end (if any) was used to make the change and you can limit the tigger to look for changes only in "priority" feilds and ingnore changes in fields you dont care about. You can also create a before and after record for a givin field.(I use this constanly in my Inventory tables).JimUsers <> Logic |
|
|
|
|
|
|
Journaling Transactions to tables