Software Applications Programming Errors and solutions.

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.