Terminating thread with TMSStoredProc in it

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 26
Joined: Wed 04 Oct 2006 01:41

Terminating thread with TMSStoredProc in it

Post by oodesigns » Wed 04 Oct 2006 01:51

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.

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Wed 04 Oct 2006 09:25

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.

Post Reply