Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
bcp ignores with(nolock) in underlaying view
0 views
Skip to first unread message
Petter Blydt Bjerkaas
Sep 15, 2000, 3:00:00 AM9/15/00
to
I experince some locking problems while using BCP. I have one process using
BCP in to different tables and another process using BCP out from views. It
seems like the BCP out is the blocking process while the BCP in is the
process being blocked. I've tried to use the parameter "with(nolock)" on the
view which seems to reduce the locks if I use the query analyser with a
select statements but doing it with BCP all the locks is still there.
BCP in to different tables and another process using BCP out from views. It
seems like the BCP out is the blocking process while the BCP in is the
process being blocked. I've tried to use the parameter "with(nolock)" on the
view which seems to reduce the locks if I use the query analyser with a
select statements but doing it with BCP all the locks is still there.
Is there a solution to avoid locking using BCP? I accept "dirty reads", but
I've found no paremeters to control the locks using BCP.
---
Petter Blydt Bjerkaas
pet...@infospine.com
0 new messages