[firebird-support] Which connection causes object in use - is there a way to find that out?

[Tomasz Tyrakowski t.tyrakow...@sol-system.pl [firebird-support]]

Hi,

 From time to time, when I try to alter a stored procedure in a 
production database, I get "object in use" error. I was wandering, is 
there a way to find the connections (users) that prevent a particular 
procedure from being altered?
Querying MON$STATEMENTS is a no-go, no statement currently being 
executed uses the procedure (directly) and yet an alter results in 
"object in use".

thanks in advance
Tomasz