Hello,

I had already disconnected all users, finally I started removing Stored
Procedures,
did all them and still could not drop the index, so I started removing
Triggers,
and after removing one of them I was allowed to drop the index. It sure
would
be nice to be able to tell where a index is in use.

Thanks
Michael L. Horne

> -----Original Message-----
> From: Milan Babuskov [mailto:milanb@...]
> Sent: Monday, December 16, 2002 1:05 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] How do I tell where a index is in use?
> (Resubmit)
>
>
> Michael L. Horne wrote:
> > Hello,
> >
> > I have decided to drop an index from one of the tables in
> > my db, but I am told it is in use. How do I determine which
> > stored procedure or trigger is using the index without deleting
> > all of them?
>
> This looks like the index is in use at the moment. Try disconnecting all
> users from database and connect then and drop index.
>
> HTH.
>
> Milan Babuskov
> http://sourceforge.net/projects/fbexport
>