Re: What causes a trigger to become disabled?

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 21 Nov 2002 23:19:08 -0000
Message-ID: <3ddd6f8c_3@mk-nntp-1.news.uk.worldonline.com>

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3DDD2E7B.911F43B2_at_exesolutions.com...
> Steve wrote:
>
> > Hello,
> > How is it possible for a trigger to appear as disabled (in
> > user_triggers) without explicity issuing ALTER TRIGGER ..DISABLE?
> >
> > We exported the db to a client site, checked for invalid objects
> > (there were none) and now a week later mysteriously proceses have
> > stopped working which we have found is related to triggers being
> > disabled.
> >
> > Here's what I checked.
> > >Ran a simple testcase with a trigger that inserts values into
> > specific columns of a table. Dropped one of the columns that the
> > trigger inserts into. The trigger shows as invalid but is still
> > enabled
> > >Droped a table that the trigger inserts into. The trigger shows as
> > invalid but is still enabled.
> >
> > I also thought that perhaps the trigger may not have got enabled on
> > import however these processes have been working fine since the import
> > until just the past day. The import occured over a week ago.
> >
> > We are 90140 on win 2k
> >
> > tks for any suggestion
>
> Modify any object upon which the trigger is dependant.
>
> Daniel Morgan
>

Daniel,

Sure, that will invalidate it, but OP was enquiring as to how it became disabled.

Regards,
Paul Received on Thu Nov 21 2002 - 17:19:08 CST