ID Number: Q40913
1.00 1.10 4.20
OS/2
Summary:
SYMPTOMS
Rules and triggers are ignored when BCP'ing data into a database.
CAUSE
Rules and triggers are ignored by BCP when data is being load into
SQL Server. This is to ensure the data is loaded into the database
in the fast manner possible.
RESOLUTION
If it is necessary to have the rules and triggers enforced, one of
the following methods should be used:
1. Load the data into an intermediate table and then use INSERT
statements to load the original table.
2. Examine the data file before loading.
3. Write the application to load the data using INSERT statements.
Additional reference words: BCP Transact-SQL Triggers Rules