I am gettting the timeout error when trying to run a large
number of update
statements within ADO.NET. I tried increasing all of the
timeouts in SQLServer (e.g. 'remote login', 'query wait'
etc. and also
the connection and query command timeouts on the client
within
ADO.NET but the problems is still there.
To give more details, let's say I want to do 10,000
updates in a for loop.
Running the sql profiler, I notice that the code works
fine and update e.g.
200 to 300 updates but after that it just hang. Nothing
happen.
Any advise would be highly appreciated. Thanks Arif