> 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.