August 29, 2003 at 5:31 pm
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
-Francisco
September 1, 2003 at 8:00 am
This was removed by the editor as SPAM
September 2, 2003 at 10:51 am
Sometimes it takes a while to clear. Check that nothing else is blocking. Worst case, restart the service.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply