Please don't post multiple threads for the same question.
No further replies here please. Replies to http://www.sqlservercentral.com/Forums/Topic1819483-3740-1.aspx
As I said in the other thread, I would recommend you not use .net, not use multiple threads, not run the process 1 row at a time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability