BUG: BCP Into Table with Constraints May Cause an Access Violation in BCP.EXE (243814)


The information in this article applies to:

  • Microsoft SQL Server 6.5 Service Pack 5a
This article was previously published under Q243814
BUG #: 18615 (SQLBUG_65)

SYMPTOMS

An access violation (AV) may occur with BCP.exe when you bulk copy data into a table that has defaults or constraints if the length of the database name exceeds 18 characters.

This problem has only been observed with the Ntwdblib.dll file version installed with SQL Server Service Pack 5a. This version of the DLL file is dated 10/8/98.

WORKAROUND

To work around this problem, use any one of the following:
  • BCP the data into a intermediate table and then insert data into the base table.
  • Revert back to an older version of the Ntwdblib.dll file.
  • Use sp_renamedb to rename the database using fewer characters.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5SP5a.
Modification Type:MajorLast Reviewed:10/17/2003
Keywords:kbbug kbpending KB243814
©2003 Microsoft Corporation. All rights reserved.