kill statement can be used to terminate a process: kill session_id kill UOW kill session_id with statusonly kill UOW with statusonly
spid of the view sys.sysprocesses. kill N with statusonly can be used to get an estimation on how far the rolling back has proceeded: kill 61 with statusonly SPID 61: transaction rollback in progress. Estimated rollback completion: 37%. Estimated time remaining: 195 seconds.