Microsoft KB Archive/243814

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

Article ID: 243814

Article Last Modified on 10/17/2003

-

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.

Keywords: kbbug kbpending KB243814

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.