> >
> > Is there another update on system tables which makes this table
> > persist?
>
> No, alas.
>
> > Is the backup process dominated by a hardwired list of
> system tables?
>
> I believe that it's the backup side that ignores anything
> marked as system. If that were changed and restore were
> tested, it might be possible to add triggers to system tables.
>
>
> Regards,
>
>
> Ann

OK seems like a perfect use of these backup restore engines which provide a
pre-backup and post-restore script to run against the DB
i.e. flag system=0 on the selected objects pre-backup and then update them
back to 1 post restore.
I'll try it
Alan