When working in SQL Server Management, it is important to make sure that you back-up all your database, to start with. Then whenever you need to update or write a Store Procedure to Update a Field in the Table, make sure that you use "Begin tran" which stand for "Begin Transaction". If you start your query with "Begin Tran" in future you might have a chance to roll-back the changes. Let's say, you updated the field in the table and then you want to undo the changes, type "Rollback;" and voila, you have the changes rolled back.
Write an Article