stopping an SQL query in the DB

  • Thread starter Thread starter Uzi Baruch
  • Start date Start date
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
 
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
 
Back
Top