Posted by pankaj_wolfhunter on 11/29/05 10:17

Actual i read something in BCP doc as below

"
-h "hint [,...n]"

Specifies the hint(s) to be used during a bulk copy of data into a
table or view. This option cannot be used when bulk copying data into
SQL Server 6.x or earlier.

Hint Description

CHECK_CONSTRAINTS Any constraints on the destination table are checked
during the bulk copy operation. By default, constraints are ignored.
Note that the max_errors option does not apply to constraint checking.
FIRE_TRIGGERS Specified with the in argument, any insert triggers
defined on the destination table will execute during the bulk copy
operation. If FIRE_TRIGGERS is not specified, no insert triggers will
execute. FIRE_TRIGGERS is ignored for the out, queryout, and format
arguments.
"

Does this mean that constraints and insert triggers will not be
checked, if not specified with this option?

[Back to original message]