PRB: BCP Ignores Rules and Triggers (40913)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft SQL Server 7.0
This article was previously published under Q40913 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:
- Load the data into an intermediate table and then use INSERT
statements to load the original table.
- Examine the data file before loading.
- Write the application to load the data using INSERT statements.
| Modification Type: | Major | Last Reviewed: | 12/3/2003 |
|---|
| Keywords: | KB40913 |
|---|
|