Just to add more to my prior posting:
MsSql 7 doesn't keep compiled version of stored procedures, only sources.
It compiled procs on demand and so a procedure can fail during execution
because one referenced object cannot be found. You can add and drop db
objects even if they are used by some procedure or trigger.
Is this model related to the loose link between triggers and tables that's
being suggested for IB?

C.

> -----Original Message-----
> From: Joseph Alba [mailto:jalba@...]
> Sent: Viernes 7 de Julio de 2000 17:05
>
> I think the question I'm posing here is:
>
> 1. Should triggers be statically linked to the owner table only? or,
> 2. Can we also have triggers as (dynamic) interfaces.
>
> Or, in Object-Oriented lingo,
>
> 1. Is a trigger A_PART_OF the table? Or, is it more like
> 2. The table HAS_(A) trigger.