Hi,

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 ?

Thanks selva

-- Anonymous, June 15, 1999

Answers

Selvanayagi,

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.

Good luck,

Eric

-- Anonymous, June 16, 1999