• tofan.nayak (1/18/2012)


    Trigger always fire when SSIS load or insert in SQl Server Database label or table base trigger

    more.....

    http://blog.sqlauthority.com/2009/05/27/sql-server-interesting-observation-of-logon-trigger-on-all-servers/%5B/quote%5D

    Not if you are doing bulk load. If you are doing bulk load, the default is to disable triggers. You can certainly turn them on, but you cannot say that they always fire.