HI Bhavbuti,

I generally manually delete the triggers from the table, prior to any maintenance that I don't need the RI for, then add them back in afterwards.

You can use SQLCURSORGETPROP() to get the triggers, bu t I don't think you can use SQLCURSORSETPROP() to add them back in again, so you need to do it manually.

I'd also be interested in any other techniques as this bites me every now and then.

FWIW, I have an audit trail which gets called in th etrigger and I have an application property that can switch it on/off as desired and then test this property at the start of the trigger. maybe you can adjust your RI code to do a similar check?


>Hi all
>
>I am supposed to do a few maintenance task on the DBC. In such a situation the RI starts firing and bringing the exe to a stop. This same problem does not happen if the project is run from the IDE.
>
>Please advise.