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