>Hi Viv
>
>The c# code is that CLR we discussed a while ago. How would I check it was being efficient and how would I change the memory allocation for SQL ? I do wonder if its some sort of resource problem as maybe the table update using the CLR creates a lot of threads simultanously. I don't know why this is not a problem on the XP development box.
>
>I have access to another 2008 server box for testing that displays the same problem.
Try adding MAXDOP hint to the query then to limit number of parallel processing to 1 and see if the problem persists.
Check this thread
http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/a5a9c595-3a3f-4b0d-8f17-467c27cee027Russel Fields suggestion in the middle of the thread.
If it's not broken, fix it until it is.
My Blog