Subject AW: [firebird-support] Monitoring service firebird 2.1
Author Olaf Kluge
Hello



Thank you very much, it works fine!



Have a nice weekend.









Hello,

> how can I view active connections in firebird 2.1 (latest release)? Do I
> need a separate tool for it? I use the EMS Firebird Manager to manage our
> databases.

Once connected to an ODS 11.1 database, you can execute the following
query to get the currently connected users to the database.

select * from mon$attachments;

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene <http://www.upscene.com> com



Internal Virus Database is out of date.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.3/1564 - Release Date: 21.07.2008
06:42
Internal Virus Database is out of date.
Checked by AVG - http://www.avg.com
Version: 8.0.138 / Virus Database: 270.5.3/1564 - Release Date: 21.07.2008
06:42


[Non-text portions of this message have been removed]