Modify your triggers to do no operations when logged in as a certain user.
That way, you do your batches as a special user, the triggers don't run, and
all other users still fire off triggers to keep your data integrity ok.

Just an idea...


Nige.

> -----Original Message-----
> From: adrian_avila_mtz [mailto:adrian_avila_mtz@...]
> Sent: Tuesday, 12 October 2004 4:21 PM
> To: firebird-support@yahoogroups.com
> Subject: RE:RE: [firebird-support] A sql sentence to innactivate all
> triggers...
>
>
>
>
> Yes, I use innactive triggers when I need to do a bach move, it is
> faster that way, I do it trigger by trigger but in a database with 140
> takes to much time, that's why I need a sql sentense to do it faster.
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
> Now with Pop-Up Blocker. Get it for free!
> http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
> __________ NOD32 1.892 (20041012) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>