Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    1

    Question Unanswered: Logging all updated values to new table??

    While creating the triggers on update, can we able to get old values for all the columns in the table?

    We are trying to do Audit Log, it should insert all the updated values to the audit log tables. Our audit log table structure is like tablename, colname, tableprimkeyid, oldvalue.

    What are the easy and efficient options I have?

  2. #2
    Join Date
    Apr 2003
    Location
    Israel
    Posts
    81
    Yes, you have the special table named "deleted" for this
    --
    kukuk

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •