Threading in SQL Server CLR procedure

F

Frank Uray

Hi all

I am having some trouble with threading in a CLR procedure.
Here is the scenario:
On a SQL Server 2008 instance I have build a CLR procedure
written in C#. The procedure works fine.
Now I have added multithreading functionality and there are
some problems:
- As longest there are no exception, all works fine (also the threads).
- But, I am unable to catch a exception and I have no plan why ...
Also debugging does not work (only for the no threading part),
cannot break within another thread.

What am I doing wrong ??

Thanks and best regards
Frank Uray
 
Joined
Mar 13, 2014
Messages
1
Reaction score
0
Hi all

I am having some trouble with threading in a CLR procedure.
Here is the scenario:
On a SQL Server 2008 instance I have build a CLR procedure
written in C#. The procedure works fine.
Now I have added multithreading functionality and there are
some problems:
- As longest there are no exception, all works fine (also the threads).
- But, I am unable to catch a exception and I have no plan why ...
Also debugging does not work (only for the no threading part),
cannot break within another thread.

What am I doing wrong ??

Thanks and best regards
Frank Uray


hi,
i have your same problem.!
no ideas and no help...
i m tring to using 2 threads but some times if i stop from sql management the sp not always catched the exception and the thread remains in loop and i need to restart the sql service by hand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top