Subject | Monitoring statements |
---|---|
Author | Indysoft Bt. |
Post date | 2009-03-10T09:56:29Z |
Hi Friends!
I'd like to monitor SQL statements in a database. I tried so many SQL
monitor application, but they didn't helped me (FBHook didn't recorded
any events.). How can I monitor any client's activity? I also tried the
MON$STATEMENTS virtual table, but I don't know what event should I use
to query its content. However the engine allowed me to create an
afterinsert trigger on this table, but the trigger didn't inserted any
data into the log table. Is there any method to achieve my goal?
TIA:Alex :-)
I'd like to monitor SQL statements in a database. I tried so many SQL
monitor application, but they didn't helped me (FBHook didn't recorded
any events.). How can I monitor any client's activity? I also tried the
MON$STATEMENTS virtual table, but I don't know what event should I use
to query its content. However the engine allowed me to create an
afterinsert trigger on this table, but the trigger didn't inserted any
data into the log table. Is there any method to achieve my goal?
TIA:Alex :-)