sql server (alternate): Greetings,
Just wanted to know if there is any parameter in BCP
utility that can ignore triggers, indexes and constraint defined for a
table?
any help will be greatly appreciated

TIA

No there isn=B4t, the only option would be to disable them prior sending
the actual statement.

HTH, Jens Suessmeyer.

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?