PRB: BCP Ignores Rules and Triggers

• Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0

SYMPTOMS

Rules and triggers are ignored when you BCP 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.

WORKAROUND

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 query words: BCP Transact-SQL Triggers Rules

Keywords : kbtool SSrvBCP
Version : 4.2
Platform : OS/2
Issue type :