cancel
Showing results for 
Search instead for 
Did you mean: 

How to log all executed queries

Former Member
2,719

I'm trying to debug a web application (connected via ODBC).

Is there a way to log all queries received by the server?

Accepted Solutions (1)

Accepted Solutions (1)

VolkerBarth
Contributor
0 Kudos

When using ODBC, I'd recommend to use the standard ODBC tracing, see the options in the ODBC admin dialog.

Answers (1)

Answers (1)

thomas_duemesnil
Participant

You can enable SQL Logging on the Server. You have to set a Log File and enable the Logging

call sa_server_option('Request_level_log_file', 'C:\\temp\\mylog.txt');
call sa_server_option('Request_level_logging', 'SQL');

If you have seen enough you can disable it

call sa_server_option('Request_level_logging', 'NONE');

Only Problem on a busy Server is that SQL from all Connections is written to the log file.

VolkerBarth
Contributor

AFAIK, you can also limit the request level logging for particular databases ("RequestFilterDB") and/or connections ("RequestFilterConn") - that may help on a busy server...