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.