This is an old known problem if IB/Firebird. You could try working on the
system tables directly:

1) Deactivate Trigger:

update rdb$triggers set rdb$trigger_inactive = 1 where rdb$trigger_name =
'YOURTRIGGER';

2) Activate Trigger:

update rdb$triggers set rdb$trigger_inactive = 0 where rdb$trigger_name =
'YOURTRIGGER';

AFAIK this should not increase the rdb$format counter

Regards
Thomas Steinmaurer

> -----Ursprüngliche Nachricht-----
> Von: Fabrice Vendé - INFOCOB [mailto:fabrice@...]
> Gesendet: Donnerstag, 29. März 2001 17:08
> An: ib-support@yahoogroups.com
> Betreff: [ib-support] Too many version problem...
>
>
> Hello,
>
> I need to exchange data between two (or more) databases. I have done a CRM
> (customer Relasionship Management) using delphi 5 and interbase 6.0. It's
> work fine.
> But :
> I have a trigger which autogenerate a reference (or for something else).
> When I exchange data between two databases (replication) I need to
> desactivate this trigger when I use "insert" clauses.
> I reactivate it after the exchange.
>
> After 255 "alter trigger XXX active/incative" I have a "two many version"
> problem and I need to backup/restore database....
>
> Why this limit and does somebody plan to correct it ?
>
> Fabrice Vendé.
>
> -
> SARL I N F O C O B
> Developpement, formation, matériel, logiciel
> http://www.infocob.com
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>