Bulk copy and trigger | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Bulk copy and trigger

Does bulk copy activate a trigger? Kindly explain if it does. Thanks.
May I suggest that you open Books OnLine on the double. Look up "bulk copy" on the Index tab, and check the sublist – there’s an entry for "FIRE_TRIGGERS" which appears to be relevant.
By default it doesn’t. You can however specify the FIRE_TRIGGER hint, which will activate all INSERT triggers. —
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Heute schon gebloggt?http://www.insidesql.de/blogs
Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
]]>