Kill Sql process with rollback time

If you want to kill any sql process for which your system is being hang or any other problem then you can read following comments.

Get SPID of process then write following command at sql query browser.

KILL 121 WITH STATUSONLY

spid 121 : Transaction rollback in progress. Estimated rollback completion: 80% Estimated time left: 10 seconds.

ReRun the same.
spid 121 : Transaction rollback in progress. Estimated rollback completion: 99% Estimated time left: 1 seconds.

Comments