Trace / Audit in ASE 11.9.2

[itguru1]

Hi all,

I am aware of a tool called "statement tracer" for oracel that gives u ALL teh quesries sent to the database. There is no need of any change or installation at the server.
Is there any such utility for ASE 11.9.2 client ??
If not... what will be the fast and easy way to do it.

Basically i want to get teh log of all sqls sent to the database by my application.

thanks a lot in advance.
Itguru

 

[gpadhy]

Yes, of course there are tools like that in Sybase

1. Auditing
2. Monitor Server / Historical Server

you have to separately install either of these utilities.

If you just want to get sqltext for a single process, then you can even use dbcc sqltext()