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.

All Forums  SQL Server 2005 Forums  Express Edition and Compact Edition (2005)  Table Locking

Author  Topic  Rliss Starting Member 31 Posts Posted - 2006-10-20 : 16:28:20 I have a batch process that runs on a table for several minutes. While the batch is running, an insert to that table gets hung until the batch completes. This does not occur in the full version, the insert does not have to wait. Is there something I can set in my batch to not lock the table? RLiss