Have you try to recreate the index and Inactivate that index ?

Regards,
Paul

> -----Original Message-----
> From: firebird-support@yahoogroups.com [mailto:firebird-
> support@yahoogroups.com] On Behalf Of PenWin
> Sent: 14 June 2008 10:05
> To: Firebird support
> Subject: [firebird-support] Deleted index renders procedures unusable
>
> I have a big problem:
>
> I decided to delete some useless indexes from my database. That went
> fine. Unfortunatelly, now just about every stored procedure fails to
> execute claiming an error that an index was unexpectedly deleted. Is
> there a way to fix this issue without dropping and recreating every
> single procedure? I am using Firebird 1.5.3 oin Superserver mode on
> Windows XP.
>
> Thanks,
>
> Pepa Kokes
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>