Andrew Guts wrote:

>
> 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.
>

The server should cache the SP while there are active connections to the
database. You may be able to get it to load the new SP if you disconnect
all users.


Paul
--

Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase