Post reply

[Trigger] Update a Datetime column when insert/update/delete

  • October 28, 2011 at 9:12 am

    #1400673

    Check the SSIS package(s). IIRC they can actually be setup to not fire triggers on insert.

  • October 28, 2011 at 9:18 am

    #1400677

    You're Right!!!

    Thank you.:-)

  • October 28, 2011 at 9:20 am

    #1400678

    Bulk operations in general, regardless of where they originate, don't fire triggers by default.

    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

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

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