0
votes
2answers
179 views

Correct procedure for preventing a spid from rolling back

Today I had a situation where I wanted to cancel an update to a table and several indexes and immediately restore back the database from a backup. I issued a kill command to kill the updating SPID. ...