Hung Process!!

[Tomi]

I deleted a database thru the Ent.Mgr and database was deleted , but the process seemed to be hung .So I went ahead
and killed the process .When I give the sp_who2 ,now it shows status as runnable and command to be killed/rollback
When I give kill now it says 'SPID 84: transaction rollback in progress. Estimated rollback completion: 100%. Estimated time remaining: 0 seconds.'
and it would'nt go off .How can i get rid of this process???

Pls help

Thanks
Tomi

 

[JayKusch]

Have/can you stop and restart sql server?

Thanks

J. Kusch

 

[Tomi]

No, Thats not possible at this time.Its a Mission critical 24/7 system.

Tomi

 

[JayKusch]

You may have a ghost spid there.

Thanks

J. Kusch