Trigger with "BULK INSERT" statement.

• wolfjr

  Say Hey Kid

  Points: 713

  More actions

  August 21, 2001 at 1:56 pm

  #101013

  Hi all,

  Does any one know what hapend whith one trigger, when I execute one "BULK INSERT" statement in one triggered table ?!

  Why trigger are not fired ?!

  Thanks

  WolfJr

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  August 21, 2001 at 3:45 pm

  #417723

  Take a look at BOL - there is a hint called FIRE_TRIGGERS you have to use with Bulk Insert or BCP.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter