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?
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.
onlychayan
Member
4 Points
38 Posts
Trigger fire during the bulk insert
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?
sqlserver 2005
tmorton
All-Star
56441 Points
9720 Posts
ASPInsiders
Moderator
Re: Trigger fire during the bulk insert
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.
ASP.NET/IIS.NET Website Manager, Neudesic