I'm trying to debug a web application (connected via ODBC). Is there a way to log all queries received by the server? asked 07 Dec '12, 03:38 MMacdonald Mark Culp |
When using ODBC, I'd recommend to use the standard ODBC tracing, see the options in the ODBC admin dialog. answered 07 Dec '12, 04:13 Volker Barth |
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. answered 07 Dec '12, 06:05 Thomas Dueme... 1
AFAIK, you can also limit the request level logging for particular databases ("RequestFilterDB") and/or connections ("RequestFilterConn") - that may help on a busy server...
(07 Dec '12, 07:18)
Volker Barth
|