Trigger Problem

  • I have a trigger that inserts data from table A into table B.  It works fine when I manually enter something into table A.  The problem I'm having is when I import data from a text file into table A.  For some reason the trigger does not work then and I'm not certain why.  Can someone shed light on this?

    I tried a couple different minor variations to the trigger.  I tried modifying the SQL statment to insert data from table A.  When that didn't work I modified it to insert from INSERTED but both had the same results I described above.

    Thanks for any insite on this.

    Brian

  • Do you use a Bulk copy to insert data ?

    If true, I don´t  know if Bulk Insert start a trigger.

     

    Please , refer Books online.

     

     


    Hildevan O Bezerra

  • Bulk Copy or BCP's will bypass triggers

  • Check this out.. another user had the very same questions:

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=161703

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply