Cancelled Sql Query Won't Go Away

pinne65

Member
I started a query against a sql data server which I later cancelled. It looked like the cancellation was stuck, so I closed the session. Bad move it seems. Even though the session is gone, it looks like the query is still chugging on. And yes, it was a bad query as well.

Is there a way to gracefully cancel that query - can I just disconnect the progress user#?

The query was started from sql server management studio against a Progress 10.02B database which is linked to from a MsSql 2005 server using the Open Edge odbc driver 5.30.00.98.
 

pinne65

Member
Apparently the ODBC driver does not support cancellation of queries. Just disconnecting the user worked fine here.
 
Top