Re: How to capture SQL_TEXT of queries?

From: Dragon Fly <dfly_at_infinet.com>
Date: 1997/04/06
Message-ID: <01bc42d7$d879e400$43f267ce@p2390>#1/1

Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in article <3347CA33.4944_at_exesolutions.com>...
> > In short, I need to set up kind of a trigger on some of the tables so
> > that it captures the text of the queries run against those tables.
>
> I may be shown to be incorrect by those more knowledgeable than I but I
> suspect it can not be done without forcing those doing the queries
> through some kind of three tier system where the middle tier does the
> capture.

how about setting up a trigger on some system table which gets updated or inserted into whenever someone runs "SELECT" ?? which table(s) might be a good candidate?

Thanks for response,
Sergei

>
> Daniel A. Morgan
>
Received on Sun Apr 06 1997 - 00:00:00 CST