a classical runaway query question: if you (or better yet your code) discovers that a query is taking too long, it would be nice to abandon and even stop this query.
On the GUI side, it is entirely possible. But giving the user a chance to start a bad query with a quick click can lead to overload.
So in addition, I would like to be able to stop the backend processing. SQLServer is the database in this case.
Any idea? Thank you.