Subject Re: object is in use
Author Dmitry Yemanov
19.08.2014 21:56, Hugo Eyng wrote:
> Sorry, but I didn´t, yet, understand why I can´t exceute an ALTER
> PROCEDURE without _*closing all conections and restarting the FB
> service.*__*

You can.

> I notice that i am not the only one facing this trouble:

They use NOWAIT transactions, hence the issue.

> Using and WAIT or NO WAIT Transaction, in my opinion, is not the answer,
> or at least no the best answer.

Maybe not the best, but it works. Do you really need to resolve the
issue or not?

> I tried to find 'who' or 'what' is using the STORED PROCEDURE while I am
> trying to excecute the ALTER, but I was not able to do it.

There are no ways to find that, except the low-level trickery with