Re: Triggers Disappearing

Bruce Bristol wrote:
>
> I happened to do a query on sys.dba_triggers and found that 3 of our 8
> triggers weren't "active" anymore - they weren't there.
>
> I ran a script to set them up again, but I'm curious as to what would
> make them go away...
>

Were they just set to inactive or did they in fact "disappear"?

If the former, any changes in dependant objects will make them inactive. If, for example, there is a call to a stored procedure in the trigger then
recompiling the sp will invalidate the trigger.

If the latter then, as the sage once said, "You in a heapa trouble, boy!"

-- 
Tomm Carr
--
"Can you describe your assailant?"
"No problem, Officer.  That's exactly what I was doing when he hit me!"