Programmaticaly cancel a SQL command sent to MS SQL Server?

[huckfinn19]

Hi!

I am using .Net's C# language in an application that is using a SQL Server database. Some of the calls in my application to the DB take quite a while to handout the results and I would like to give my users the possibility to cancel the request if they think it's taking too long. When using the SQL Enterprise application, there is a cancel button that can be hit to stop the request in the middle of it's processing, so I guess it's also possible programmatically.

Therefore, I would like to know if someone could guide me on how to programmatically and asynchronously cancel a SQL command that was sent to SQL Server?

Thanks!

Huck

 

[Korach]

Use threads. Open a new thread and give it the sql job. When the user press on something, call Thread.Abort()

 

[huckfinn19]

Hi Korach, thanks for your answer. Your solution will work fine, the only concern I have with it is that the job might keep running on the distant SQL Server? I might be wrong, I wonder what happens when a connection is closed with the server like it will happen when I call the abort on the thread.

 

[Korach]

I think who developed SQL Server thought about that, but ask this question in the SQL Server forum.