SqlBulkCopy Tutorial - Knowledge Base (KB)

When does SqlBulkCopy check for constraints?

If SqlBulkCopyOptions.CheckConstraints option is set for SqlBulkCopy insert, does it check the constraints separately after each record, or after all records are inserted?...I have a check constraint that compares some columns to the parent row (through a...

Finding the rows that caused the constraint failure

Any idea if it's possible to get a list of the trouble making rows in an INSERT/UPDATE statement when a constraint test fails? ...I'm trying to insert data with an SQLBulkCopy object reading data from a DataTable, and when the constraint fails I have no w...