Triggers in BCPgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
How could I get triggers fired during BCP operation ? SQL Server 7 features the foresaid option but I could find no way of using this option during BCP operation. How can I do it ?
-- Anonymous, June 15, 1999
With SQL 6.5, triggers are not fired when you do a bcp, even in "slow" mode. With SQL 7.0, by default, triggers are not fired when you do a bcp, but then can be if you specify the "CHECK CONSTRAINTS" option. See the SQL Server Books Online for more details.
-- Anonymous, June 16, 1999