Active is the default state at creation.
One way to produce inactive indexes is to restore with an option to do so.

C.

> -----Original Message-----
> From: Carl J. Mosca [mailto:cmosca@...]
> Sent: Jueves 22 de Junio de 2000 22:00
>
> Just out of curiosity...I thought the default state for a trigger was
> Active.