Explicit locking

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

Does SqlDataAdaptor do an explicit table lock when calling Update? We have
an importer that connect to SQL Server 2000 and anytime imports are being
written to a table and a query is ran against that table at the same time we
get a timeout exception.

Not locking the table is fine for us because the imports don't effect any
user and is only done by one person.
 
Hi,

I do not think it makes any locking unless it is required to update specific
record. After this locking should be released.
 
Back
Top