Microsoft KB Archive/69283

= INF: Using BCP to Load Data into SQL Table with Unique Index =

Article ID: 69283

Article Last Modified on 11/14/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q69283



SUMMARY
BCP (bulk copy program) handles the loading of duplicate data into a table that has a unique index by stopping the processing of the data file and rolling back all records. In other words, no records are loaded into the table.

The rollback affects all rows up until the duplicate is encountered if no batchsize (-b) option was used.

In addition, if the index was created with IGNORE_DUP_KEY, the encountering of a duplicate during bcp has no effect. In other words, no rollback occurs and the bcp will continue.

Keywords: kbinfo KB69283

-

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

© Microsoft Corporation. All rights reserved.