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.
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
Post a Comment
Please avoid link comments