Hello,

is there a way to check if logging of sql statetments is
enabled on a ASA 9.0 server? I need to query this with via
sql.

Thank you.

Kind regards
Andreas

Use:
SELECT property('RequestLogging')

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




AH wrote:

Can I be sure, that there is no logging at all, if this
responds with NONE? I know that UPDATEs and INSERTs are
"logged" in the transaction log. Is there any other way of
logging SQL statements? For example with Sybase Central? I
don't want to know how, I just need to detect it.

Thanks a lot in advance.

Andreas

DDL statements (e.g. CREATE, ALTER, DROP) will be recorded in the transaction log.

Auditing could be used to record information in the transaction log about
statements other than DML statements. See connection_property('auditing').

Triggers could record information about INSERTs, UPDATEs and DELETEs performed
using tables other than those being modified. They could also output information
to the server's console log via MESSAGE statements.

Sybase Central and DBISQL have the ability to record statements executed at the
client. This is done independently of the server.

Client-side tracing (e.g. ODBC tracing) could also be used to record statements
executed; however, this cannot be detected at the server.

Your original post was a bit vague about what you wanted to detect and why.

SQL Anywhere Developer Community:
http://www.sybase.com/developer/libr...ere-techcorner


SQL Anywhere Blog Center: http://www.sybase.com/sqlanyblogs




AH wrote:

Ok, this helped a lot. I want to check if any logging is
enabled on server-side to avoid an easy way of reverse
engeniering. Client-side is not the problem for my app. I
want to disable functions in my app if any serverside
logging is enabled besides transaction log.

Andreas