By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

BCP Large Table.

P: n/a
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.

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
LineVoltageHalogen (tr****************@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, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.