Post reply

SQL statement stuck in loop...Urgent pls. help...

  • April 6, 2005 at 10:28 am

    #87186

    It started after a DTS package Job got hung and it had to be stopped manually. Job status has changed to "Not Running" but apparantly a Delete statement has stuck into infinite loop.

    Here is the data from SQL profiler:

    Application Name: Microsoft SQL Server

    ClientProcessID: 23895

    SPID: "Keeps Changing"

    TextData: Delete statement.... Network Protocol ---LPC

    Can't restart SQLServer right now, is there any other option?

  • April 6, 2005 at 10:32 am

    #550841

    You could find out the SPID of your process and kill that process.  It could be stuck in roll back depending on how many rows are being deleted.  After rollback.  You could copy your sql statement and try to work on your query.  Note, If you are not too skill, I would advice you replacing delete with select statement and run it using query analyzer to verify how much damage you will receive before actually issuing final delete statement.  Good luck.

     

    mom

  • April 6, 2005 at 10:45 am

    #550845

    SPID keeps changing, so I can't kill it based on that. Is there a way to kill based on ClientProcessID?

Viewing 3 posts - 1 through 2 (of 2 total)

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