Trigger is not working

Posted by Sarvesh under Sql Server on 12/8/2009 | Views : 2595 | Status : [Member] | Replies : 1

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

hi Experts

please clarify the following issue.

I am using one table 'tbscenario'.

I am trying to import data from bcp command to the table 'tbscenario'.

The import performs well.

BUT. we have defined one TRIGGER (INSERT) on 'tbscenario'. The TRIGGERS is not working when I am using the bcp oprtation.

Is there any technical issue/What I am doing is wrong ?

thanks in advance
Sarvesh

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Pandians on: 12/8/2009 [Member] [MVP] Silver

0	Hi Yes. Here some technical limitations are there. 1. When doing Bulk operation like BCP, BULK INSERT, Triggers will be DISABLED automatically. 2. If you realy need to trigger the Trigger pl use the hint or parameters like... Use -h "FIRE_TRIGGERS" with BCP command Use FIRE_TRIGGERS with BULK INSERT statement Then only the Trigger will raise... Cheers Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions Sarvesh, if this helps please login to Mark As Answer. \| Alert Moderator

Hi

Yes. Here some technical limitations are there.

1. When doing Bulk operation like BCP, BULK INSERT, Triggers will be DISABLED automatically.

2. If you realy need to trigger the Trigger pl use the hint or parameters like...

Use -h "FIRE_TRIGGERS" with BCP command

Use FIRE_TRIGGERS with BULK INSERT statement

Then only the Trigger will raise...

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

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

Latest Posts