Hi all,

im trying to figure out how to do the following.
I have a table orders, tbl_Orders, and a backup orders table tbl_Orders_bak.

Each time a record is updated from the tbl_Orders i want to take a copy of the entire row before the update occurs and put it into the tbl_Orders_bak

what the best to do this. I would have thought a BEFORE UPDATE trigger but it doesnt exist in SQL Server