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
