SQL Server Performance Forum – Threads Archive
Kill Without Rollback
Hi, Assuming that I have a huge update transaction running and let’s say for some reasons the transaction was cancelled inadvertently or connection was broken. With this, I understand that the transaction is rollback. Is there a command that will kill the process without waiting for the rollback to finish? Another scenario would be, let’s say I’d like to cancel a huge transaction that has been running for 1 or 2 hrs. Can I kill the process without rollback? Jon MI think there is no way to kill whithout rollback.
Even if, after kill, you down service, when restart sql try to rollback again.
I suggest to wait for others post.
Luis Martin
Moderator
SQL-Server-Performance.com
luis is right, no you cannot. It would violate the principles of relational database theory Cheers
Twan
]]>