Hello,
I do hope somebody has already solved my problem.
I have an application that spawns 4 different threads.  Each thread
will perform it's own task which is calling a stored procedure.  Each
stored procedure could possibly run a very long time.  The user should
be able to stop any of the tasks he started.  Stopping a task means
stopping a stored procedure and doing the clean up of the affected
tables.
My only idea on how to stop a stored proc is to close the database
connection that the thread is using to call a stored procedure.  I'm
not sure it's such a good idea though...  What are my options?
I would appreciate any help on this matter.
Thanks in advance.
NK