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 |
|
Rauken
Posting Yak Master
108 Posts |
 Posted - 2007-03-02 : 06:53:38
|
| I have a small webapplication, sql server 2000. The users can only update the data in the system. However my client needs a report that display changes. The changes are that needs to be monitored are only change of order status, change of delivery date and when a user splits an order. What is the best practice to keep track of changes? A mirror table for each table with changes? /Magnus |
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-02 : 08:07:57
|
| Create a trigger on the table and write the old and new values to another table (History). Use can use the inserted and deleted temp tables to find and retrieve records that were changed.Raymond LaubertMCDBA, MCITP:Administration, MCT |
 |
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2007-03-02 : 08:29:19
|
| Thanks! That's what I'm doing now :-) |
|
|
|
|
|
|
Row versioning best practice