Thread: Tracking who is changing what?
View Single Post
  #3 (permalink)  
Old 08-09-06, 13:51
Thrasymachus Thrasymachus is offline
SQL Server Street Fighter
  
Join Date: Nov 2004
Location: Down The Rabbit Hole
Posts: 7,766
Our application has History tables and triggers on the live tables that log every change to the table. 2 keys to making this work is to have date the change was made and an extra field on the history table that is an incrementing identifier.
__________________
software development is where smart people go to waste their lives
Reply With Quote