Results 1 to 5 of 5

Thread: triggers

  1. #1
    Join Date
    May 2004
    Posts
    36

    Unanswered: triggers

    can a trigger on a table be fired after a bulk insert???

  2. #2
    Join Date
    Dec 2002
    Location
    Antwerp, Belgium
    Posts
    227
    you can specify the option 'FIRE_TRIGGERS' in a bulk insert statement (see under bulk insert in books online). IF this option is set, insert triggers are fired after every batch. So if you use one batch, the trigger is fired only once.
    Johan

  3. #3
    Join Date
    May 2004
    Posts
    36
    thanks...........

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    If your doing a BULK INSERT, then it's most likely a batch process, so why use a trigger?

    Make it part of that unit of work....

    No?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    May 2004
    Posts
    36
    sorry but i don't understand... what do u mean???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •