How can I cancel a long-running query from my code in a differentthread

B

Big Daddy

If I have a thread that running a long query, is it possible for a
different thread to cancel the query? I am using SQL Server and C#.
I have tried aborting the thread that is doing the query, and that
doesn't work. I have tried using a different thread to run a KILL
command on the SQL Server, and that is successful. But in order to
run a KILL command, I have to know the SPID of the query that should
be killed. I don't know how to get this. I am using the Entity
Framework for the long-running query. I am wondering if there's a way
to find the SPID of the query being run through EF. I could try to
run a query that says "select @@SPID" before running the long-running
query, but I don' know how to do this with my EF objects. Any ideas?

thanks in advance,
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

add STOP button, to cancel the query process 2
Access Running Balance in Access 1
Cancelling query with ADO and Oracle 1
Am I disturbing a machine in production floor if I access its database remotely? 4
How to cancel a long query 3
BackgroundWorkers and ADO.Net 1
Stopping a Query 1
Aborting a thread corrupts my SqlConnection (?) 4

Top