Threading in SQL Server CLR procedure

  • Thread starter Thread starter Frank Uray
  • Start date Start date
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
 
Frank Uray said:
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
Click to expand...


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...
 
Back
Top