Hi,

> > > 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.
> >
> > I believe everyone needs to disconnect - metadata is cached
> > on the server side.
>
> AFAIK, not really. When a SP is altered, its new metadata is reloaded to

the

> cache, but already compiled requests see the old version. So the only
> required thing should be to commit/rollback all running transactions that
> could explicitly or implicitly use this SP and then restart them.

That would explain why you can happily test when you're pretty much the
only one connected :)

Thanks,

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