Browse by Tags

All Tags » trigger (RSS)
10 October 2009 22:45

DISABLE TRIGGER not captured, SSIS

This post was to be about behavior of SSIS when they insert rows to tables with triggers on them. We had an issue with one of our packs that began to fail 'all of a sudden'. But when I began writing this post and building test SSIS project and...
Posted by Piotr Rodak | 1 comment(s)
Filed under: , , , , , , ,
29 October 2007 20:37

distributed transactions and triggers

Last week I came across an interesting issue. If you have a FOR INSERT trigger on a table and you want to store some information on a linked server, the transaction the trigger is running within is automatically expanded to distributed mode. This creates...
Posted by Piotr Rodak | with no comments
Filed under: , ,