Post reply

Tracking Database record changes

  • December 3, 2005 at 9:18 am

    #102968

    Dear Friends,

    How do i track database record changes.

    when the user changes any value in any of the tables in the database i need to log that changes. how do i do it

    Thanks,

     

  • December 3, 2005 at 12:43 pm

    #607579

    Research the use of triggers on the table to track the changes or put the audit trail within the stored procedures used to update the tables.  If users can directly modify records, then you are probably stuck with triggers as your only option.

    If the phone doesn't ring...It's me.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply