Hi guys,

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


Dmitry