Trigger fire during the bulk insert

Posted by Ray.chayan under Sql Server on 7/15/2010 | Views : 3210 | Status : [Member] | Replies : 1
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?




Responses

Posted by: PandianS on: 7/15/2010 [Member] [MVP] Silver

Up
0
Down
hi

If you using "BULK INSERT" command then, You have to Enable the Qualifier "FIRE_TRIGGERS"
(or)
If you using "Bcp" command then, You have to use the "-h" option with the "FIRE_TRIGGERS" hint

Cheers


Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Ray.chayan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response