Hello,

I have a multithread method that calls a really long SP. It takes around 2
hours to run. this method is in a Webservice. I'm using Thread object to
control the multithread procedure and each thread creates it own data
connection to avoid connection already open exception.

It starts OK, runs for sometime and just drops. I have created a log
procedure to trace it and it looks like .NET is dropping the thread together
with the data connection.

I tried with other SPs and works fine but for this long one it doesn't.

Should I remove the Thread object and call the async webservice method
instead?
Could this be some kind of timeout?

Thank you