Subject Re: [firebird-support] Saving SQL
Author Thomas Steinmaurer
Hello Michael,

> I have en external connection to one of our DBs.
> I suspect this connection to do some heavy DB querys.
> I have created an DB trigger to log connect, disconnect, start, commit and rollback from this user (and 3 others as a reference).
> Is there anyway I can save the SQL the user is executing?

Yes, by querying the MON$ tables joining with some DB trigger context
not sure about the performance penalty.

With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

Do you care about the future of Firebird? Join the Firebird Foundation: