Post reply

kill user

  • June 2, 2006 at 6:35 am

    #115442

    Hi all

    I am trying to kill @spid

    but it does not work.

    What is the alternat way to do it.

    Thanks

  • June 2, 2006 at 6:50 am

    #641401

    Try killing it from EM.

     

    ------------
    Prakash Sawant

    http://psawant.blogspot.com

  • June 2, 2006 at 7:01 am

    #641406

    I tried but did not work!!

  • June 2, 2006 at 8:30 am

    #641453

    Hi

    Can u please tell what is the error or problem u r facing while using kill @spid

  • June 2, 2006 at 8:31 am

    #641457

    There is no error while running kill @spid

    i get this

    it returns this

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

    But the process is still running and did not finished at all!!

  • June 4, 2006 at 3:34 am

    #641583

    what is the output of

    dbcc inputbuffer(<SPID&gt

    Restarting should solve this

  • June 5, 2006 at 3:04 am

    #641611

    Try

    KILL {spid}   [WITH STATUSONLY]

    Statusonly : displays the current progress report.

    Also on SP_Who2 output check the staus of the SPID. If it is "Killed/ Rollback" you have restart the SQLServices.

     

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • June 5, 2006 at 2:28 pm

    #641824

    You have an orphaned transaction, the only way I know how to get rid of these spids is to stop and start SQL.

  • June 6, 2006 at 3:46 am

    #641894

    Hi

     

    Yes restarting the server should solve the problem.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply