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
oodesigns
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.
Top
Jackson
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.
Top
Post Reply

Return to “SQL Server Data Access Components”