BCP Large Table.

If I use BCP to export a very large table will that table be blocked
for writes during the export process? I don't want to prevent users
from accessing that table during the bcp process?

Thank You, TFD.LineVoltageHalogen (tropicalfruitdrops@.yahoo.com) writes:
> If I use BCP to export a very large table will that table be blocked
> for writes during the export process? I don't want to prevent users
> from accessing that table during the bcp process?

A quick test indicates that BCP takes out shared page locks as goes,
and an Intend Share lock on table level. While the BCP was running I
was able to perform an update on the table. A writer that would require
a table lock for his update would be locked, though, I guess. But you
should not have any such writers.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp