显示标签为“writes”的博文。显示所有博文
显示标签为“writes”的博文。显示所有博文

2012年3月19日星期一

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

2012年2月16日星期四

bckhist.cpp - Failed Assertion = 'm_markCVount < m_maxLogMarks'

The SQL Server (Product Version 8.00..., SQL Server 2000) writes the follow
ing errors:
- SQL Server Assertion: File: >bckhist.cpp>, line=1742, Failed Assertion = '
m_MarkCount < m_maxLogMarks'
- Error: 3624, Severity: 20, State:1
- Error: 3449, Severity: 21, State:1, An error has occured that reequires SQ
LServer to shutdown so that recovery can be performed on database ID...
After these errors -> the SQLServer shutdown...
Please Help, thanks!This maybe an issue with the use of begin transaction with Mark Argument
that updates a table with trigger with insert.
Remove the with Mark argument from the being transaction to avoid the
issue.
If you need further information, I would suggest you open a call with
Microsoft support that will be able to assist you further with this issue.
Regards
Agnes Panosian
SQL Server Support