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 |
|
jigsatics
Starting Member
18 Posts |
 Posted - 2006-01-20 : 18:04:19
|
| Hi!I have a Mailout table with a MID, ADDRESS, CITY, POSTCODE linked to another table called History which contains events that are associated with each Mailout record. I need to create an audit trail based on the MID of the mailout table that would tell me how many records are currently in event 1,in event 2 etc.I'm thinking of creating an audit trail table that would store the data as well as create triggers to check on any change(add/deletions/updates) of the status of each record. Is this the best way of doing it? Or are there any other ways of achieving an audit trail? $3.99/yr .COM!http://www.greatdomains4less.com |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-20 : 18:10:32
|
| How accurate does your audit trail have to be? If the counts for the events can be a little old, I'd suggest scheduling a job to update your audit trail table rather than having the overhead of triggers. You can schedule the job to run as often as you'd like.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Best way of creating audit trail