Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    10

    Unanswered: [help] back up a table (data) on update

    Is there any stored procedure, that backups the whole table before users commit the updates (insert, delete, update)? or for running a daily job to back up the whole table?

    Thanks a lot.

    W-

  2. #2
    Join Date
    Jul 2002
    Location
    California, US
    Posts
    21

    Re: [help] back up a table (data) on update

    Originally posted by wishmaster
    Is there any stored procedure, that backups the whole table before users commit the updates (insert, delete, update)? or for running a daily job to back up the whole table?

    Thanks a lot.

    W-
    You can create a history table and use appropriate trigger to populate the data from source table.
    Thazul

Posting Permissions

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