GilaMonster (3/3/2013)
Welsh Corgi (3/3/2013)
Most times I've seen that it's been a process that has some external component. DTC, remote procedure call, external access, extended procedure, backup. Killing a normal SQL process you shouldn't have any problems. Just don't do anything silly like restarting SQL part way through a rollback or deleting the transaction log.
Yes but what do you do when the rollback does not make any process 0% of 0% completed?
byw, The situation does not fall into any of the categories that you mentioned.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/