How To Cancel Long Running Query ?

How To Cancel Long Running Query ?

Post by Tom Jastrzebsk » Fri, 14 Feb 2003 22:19:12

Hi everybody!
Is there any way I could cancel long running sql query on SQL Server 2000 ?
According to the docs killing a process is not possible wile executing
SELECT statement.
Is there any other tricky or secret way to do it ?

Tom Jastrzebski


1. Canceling a LONG running query?

Hi All,

I have an application that can potentially allow a user run a query that can
take a very long time to return a recordset. I'd like to know how to get my
application to accept a "cancellation" of the running query process. I've
tried setting an optional recordset parameter of "adAsyncExecute" but when
run, I cannot click the cancel button.

Any insight would be greatly appreciated!

TIA -- Fred

2. renameing a file

3. OO4O + VC++: How do you cancel a long-running query

4. dBase 5 Win and Crystal Reports Pro

5. Cancel long running Queries in OCI

6. ORACLE_PATH variable

7. Canceling a long Query?

8. I/O Performance

9. SQL Worksheet - canceling long queries

10. Sybase ver. 11/NT - long query canceled

11. status when running an long run insert query

12. How to Cancel a L O N G running Sql Query with ADO

13. : Cancel a running SQL query