Post reply

bulk insert not firing triggers ?

  • June 10, 2013 at 9:24 am

    #394939

    hi

    i have table with triggers on the table while bulk inserting it is not firing

    what is the problem

    ?

    with best regards

    Pradeep

  • June 10, 2013 at 9:32 am

    #1622499

    Bulk Insert does not fire triggers by default. If you want a bulk insert to fire triggers, you have to specify.

    From Books Online entry titled BULK INSERT:

    FIRE_TRIGGERS

    Specifies that any insert triggers defined on the destination table execute during the bulk-import operation. If triggers are defined for INSERT operations on the target table, they are fired for every completed batch.

    If FIRE_TRIGGERS is not specified, no insert triggers execute.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 10, 2013 at 9:34 am

    #1622500

    As far as im aware a BULK insert causes and Triggers to be ignored, Further Reading: http://msdn.microsoft.com/en-us/library/ms187640(v=sql.105).aspx

    _________________________________________________________________________
    SSC Guide to Posting and Best Practices

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

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