If i update or delete some set of record then how do i rollback the changes. Is there any query for it. for e.g. if i run the following query: Update salesproposal set statuscode = 4 where so_id = 47888 How do i rollback this query in SQL Server. Thanks for your responses!!!