|
|
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?
Navigation:
[Reply to this message]
|