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.
You can create a history table and use appropriate trigger to populate the data from source table.