Results 1 to 2 of 2

Thread: SQL Statements

  1. #1
    Join Date
    Feb 2002
    Posts
    96

    Exclamation Unanswered: SQL Statements

    Dear all,

    Is there any way to get all the SQL statements which have been executed since last ACTIVATE database connection?

    Thanks alot in advance.

    Regards
    Prakash

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    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.

    Cheers,

    Willy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •