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 information (CURRENT_CONNECTION, CURRENT_TRANSACTION ...), although I'm not sure about the performance penalty. -- With regards, Thomas Steinmaurer (^TS^) Firebird Technology Evangelist http://www.upscene.com/ Do you care about the future of Firebird? Join the Firebird Foundation: http://www.firebirdsql.org/en/firebird-foundation/
