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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 How to report table changes???

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-03 : 08:52:14
john writes "What is the best way to capture changes made to tables for reporting purposes?? Users need a report that shows all adds/updates/deletes made to certain tables. These tables are changed in more than one program. They also need to see the before and after values of the fields in the case of updates. Would triggers be the best way to solve this programming challenge??"
   

- Advertisement -