Subject Re: altering triggers from sp
Author Svein Erling Tysvær
Why not write a stored procedure and only do the recalculation if you
pass a particular value for a parameter?


--- In, "kaczy27" wrote:
> --- In, Lucas Franzen wrote:
> >
> > Kaczy,
> > Deactivating a trigger is anything BUT multiuser safe.
> >
> :),
> ok, point taken,
> since it is the speed not the space that is important I guess I'll
> invest into another column in a million record table, or perhaps
> I'll create another table just to store the records that need to be
> recalculated and store the trigger there. It will break somewhat the
> design, but still what for one would need a design if the instance
> doesn't work.
> Thank you all very much for your input.
> > Luc.
> CUIN Kaczy