Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bwwhitney
Starting Member
1 Post |
 Posted - 2007-01-05 : 09:55:54
|
| We've come across a strange problem using an SQLDataAdapter to update a large amount of data. We've had no problem using the same code for a smaller amount of data, and we only come across the problem once the amount of data is past some threshold. With Profiler running, we can watch the insert statements executing until some random time, when they will simply stop executing and it will hang until the DataAdapter CommandTimeout is exceeded. This is on a test Database which is not in use by any other users. We've tried changing the UpdateBatchSize, with no real differences. Any ideas? |
|
|
|
|
|
SQLDataAdapter update hanging