If your SP don't have any dependencies, try do Drop it and create it again.

Artur

----- Original Message -----
From: "Martijn Tonies" <m.tonies@...>
To: <ib-support@yahoogroups.com>
Sent: Monday, August 12, 2002 2:18 PM
Subject: Re: [ib-support] How to alter SP wihout restarting the server?


> Hi Andrew,
>
> I believe everyone needs to disconnect - metadata is cached on the server
> side.
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
> > How to alter SP wihout restarting the server? Is it any way to enforce
> > the server to accept changes. After altering the stored procedure server
> > continues to work with old instance till restart. Please help.
> >
> > Thanks ahead
> >
> > Andrew
>
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>