stopping an SQL query in the DB

U

Uzi Baruch

Hi!



i was wandering if there is a way to stop a query after it was executed on
the database.



I’ve built a query tool that enables a user to query on any criteria type he
want, the problem is that I need to give the option of stopping the query,
which programmatically is due able, but at the application level. What i
want is to stop it at the database level - similarly to what query analyzer
does.



Thanks,

Uzi
 
W

William Ryan

You can try Command.Cancel, but that's not always 100% effective. Niether
though is QA. There are many times you can hit stop in QA and it will still
run for a while before stopping. The same is the case with Cancel. I've
had it work as expected a few times, but seldom have I had it totally stop
immediately upon calling it...just like QA>

HTH,

Bill
 

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

Stopping a Query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Am I disturbing a machine in production floor if I access its database remotely? 4
Access Query criteria based on other field of the same query 0
using go in a sql batch 2
Query inside of Access Database 9
Access Access Report Works on One Machine but not Another 3
SQL Server Application Roles 1

Top