How do SQL 2008 : Kill a runaway process that I cant stop nor identify. Original query was infinite loop that we aborted.

Posted on 2011-10-04
Last Modified: 2012-05-12
How do Kill a runaway process that I cant stop nor identify. Original query was infinite loop that we aborted.

Proces was kicked off via web app that called a SP.
Its queueing emails nonstop.
The query was a loop that sent out emails.

We have restarted SQl, Server Agent and restarted the server Only thing left to try is get out the 12 gauge.

 Lost on how to kill  or identify this runaway process. Its sending mail and has my dbmail server clogged.

Help needed asap.

Question by:LeadCo
    LVL 5

    Accepted Solution

    In  sql server 2008
    use master
    select * from sysprocesses (nolock) where blocked = 0 and spid !=@@spid
    and then use

    --Kill spid  

    Which you want to kill

    Other then through SSMS identify and Kill the perticular process ID

    You can use this Link reference

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    This is a fairly complicated script that will install the required prerequisites to install SCCM 2012 R2 on a server.  It was designed under the functional model in order to compartmentalize each step required, reducing the overall complexity.  The …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now