Trigger is not working

Posted by Sarvesh under Sql Server on 12/8/2009 | Views : 1574 | Status : [Member] | Replies : 1
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




Responses

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

Up
0
Down
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

Login to post response