Ravi Shekhar

Ravi Shekhar

  • 361
  • 4.5k
  • 2.1m

rollback of last updated queries in sql server

Aug 28 2013 5:45 AM


Hello seniors,

I have two  buttons. On the click of first button i update some rows in sql server table.
but my operation will complete after click on second button.

suppose after clicking on first button my server will close enexpectedly or someone close server directly. 
Is there any option availiable in sql server to rollback my last update query if the server is down enexpectedly.


Please give suggestion.

Answers (16)