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

ID: Q243814


The information in this article applies to:
  • Microsoft SQL Server version 6.5 Service Pack 5a

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 version 6.5SP5a.

Additional query words:

Keywords :
Version : winnt:6.5 Service Pack 5a
Platform : winnt
Issue type : kbbug


Last Reviewed: December 2, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.