You could use locking hints like TABLock or HoldLock. Alternatively you could set a higher transaction isolation level and do your inserts. Bear in mind that these have their own "side effects" . It would be better if you explain in detail what you want.