---In firebird-support@yahoogroups.com, <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

  • [firebird-... Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
    • [fire... hv...@users.sourceforge.net [firebird-support]
      • R... Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]
        • ... rgilland1...@gmail.com [firebird-support]

Reply via email to