Post reply

Trigger Problem

  • February 14, 2005 at 6:09 am

    #163737

    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

  • February 14, 2005 at 6:20 am

    #542024

    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

  • February 15, 2005 at 11:19 am

    #542355

    Bulk Copy or BCP's will bypass triggers

  • February 15, 2005 at 11:56 am

    #542371

    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