Trigger fire during the bulk insert

Posted by Ray.chayan under Sql Server on 7/15/2010 | Views : 4705 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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?

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

Latest Posts