Microsoft KB Archive/40913

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


PRB: BCP Ignores Rules and Triggers

Article ID: 40913

Article Last Modified on 12/3/2003



APPLIES TO

  • Microsoft SQL Server 4.21a Standard Edition
  • Microsoft SQL Server 6.0 Standard Edition
  • Microsoft SQL Server 6.5 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition



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:

  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: KB40913