Cannot Kill Process  
Author Message
Svandisel





PostPosted: Tue Feb 08 16:43:07 CST 2005 Top

SQL Server >> Cannot Kill Process

SPID 84: transaction rollback in progress. Estimated rollback completion:
100%. Estimated time remaining: 0 seconds.

I've tried to kill this several times. It appears as though it should be
completed but it's**** for some reason.

Any help would be appreciated.

Thanks!

SQL Server6  
 
 
FK





PostPosted: Tue Feb 08 16:43:07 CST 2005 Top

SQL Server >> Cannot Kill Process I found the process in windows task manager. Killing the process through
there allowed me to then kill it through the KILL (SPID) command.



> SPID 84: transaction rollback in progress. Estimated rollback completion:
> 100%. Estimated time remaining: 0 seconds.
>
> I've tried to kill this several times. It appears as though it should be
> completed but it's**** for some reason.
>
> Any help would be appreciated.
>
> Thanks!