Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jul 15, 2010 05:27 PM by tmorton
Jul 15, 2010 03:32 PM|LINK
I have written a trigger against the insert command on a particular table. Now I am inserting a bulk data in this table . Now what should happen? In my case no trigger fire is occurred. If it is natural that trigger will not fire during the bulk insert then
what is the reason behind it?
Jul 15, 2010 05:27 PM|LINK
You might find this article from the MSDN library to be helpful:
Controlling Trigger Execution When Bulk Importing Data. Triggers are not enabled by default because of the potential performance hit and other complications. You can specify FIRE_TRIGGERS if you want them to fire regardless.