Hello all...we are using the transaction log to view all our
changes to our database. I was just wondering if there was
anyway to capture the SELECT statement in this log whenever
a user selects from the db? Any info would be greatly
appreciated

SELECTs are not recorded in the transaction log. "It stores all changes
to the database. Inserts, updates, deletes, commits, rollbacks, and
database schema changes are all logged."

Mark wrote:

Mark,

the translog usually only captures modifications, so simple SELECTs are
not logged.
However, you can use the auditing facility to log SELECTs, too.
For SA 11.0.1, here's the DocumentXchange link:

http://dcx.sybase.com/index.php#http...-security.html


HTH
Volker



Mark wrote:

Thanks guys for the info...

Auditing is expensive, in that it adds huge amounts of data to the
transaction log. Moreover, auditing will require additional processing
to extract the queries from the log into a more useful format.

A better choice would be to use database tracing, the customized method
for profiling an application available in Sybase Central.

Glenn

Mark wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport