Page 1 of 1

Terminating thread with TMSStoredProc in it

Posted: Wed 04 Oct 2006 01:51
by oodesigns
If a query or a execute form a tmsstoredproc takes too long I would like to terminate it.

The termiation would be done from another thread.

What is the best way to go.

Posted: Wed 04 Oct 2006 09:25
by Jackson
You are right. You can call BreakExec to break execution of stored procedure on the server.
It makes sense to call BreakExec only from another thread.