Help... I have a run away transaction...
this process was supposed to be an insert to a table... but the process has the table locked that I can't even run a simple drop table if I wanted to 🙁
here is the results from me trying to kill off this spid..
SPID 55: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.
but it's still there.. the status is "KILLED/ROLLBACk" what can I do short of shutting down the server????
-Francisco