var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: SQL Statements
Is there any way to get all the SQL statements which have been executed since last ACTIVATE database connection?
Thanks alot in advance.
Not sure if you are talking ASA or ASE???
In ASA, it is quite easy. Simply translate the log since the last checkpoint and you'll see all the SQL's.
In ASE..Yeah...if you install Auditing.
Set up Auditing on this database. You have to create a sybsecurity database and install the sybsecurity script. Enable Auditing and start auditing.
Or you can use trace flags(contact Syabse Support) to log SQL's into the errorlog.
Or use a third party product like DB-Xray that monitors all SQL's.