> Hello!
>
>
> May I use the system table "MON$ATTACHMENT" in order to get the connected
> users in moment?
>
>
> I already try to do it, but when a connection from a client (another
> machine) is ended abnormally (for example, turn off the machine or
> disconnect the cable of network), this connection still stay on system
> table "MON$ATTACHMENT".
>
>
> There are a way to "refresh" this system table?

Does it help when you query the monitoring tables in a new transaction context?


--
With regards,
Thomas Steinmaurer
http://www.upscene.com

Professional Tools and Services for Firebird
FB TraceManager, IB LogManager, Database Health Check, Tuning etc.