By default, SqlBulkCopy does not honor triggers or foreign key constraints. You should always include the options SqlBulkCopyOptions.FireTriggers and SqlBulkCopyOptions.CheckConstraints. (I...