SQL Server Performance Forum – Threads Archive
Kill Without RollbackHi, 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 M
I 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 is right, no you cannot. It would violate the principles of relational database theory Cheers