---In [email protected], <t.tyrakowski@...> wrote : > From time to time, when I try to alter a stored procedure in a > production database, I get "object in use" error.
Run DDL statement in wait transaction. Better to set some timeout to not wait too much, but not no-wait mode > I was wandering, is > there a way to find the connections (users) that prevent a particular > procedure from being altered? No, sorry (one can use lock manager but it is not trivial) Regards, Vlad
