on 2012 Dec 07 3:38 AM
I'm trying to debug a web application (connected via ODBC).
Is there a way to log all queries received by the server?
Request clarification before answering.
When using ODBC, I'd recommend to use the standard ODBC tracing, see the options in the ODBC admin dialog.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
AFAIK, you can also limit the request level logging for particular databases ("RequestFilterDB") and/or connections ("RequestFilterConn") - that may help on a busy server...
User | Count |
---|---|
52 | |
8 | |
5 | |
5 | |
5 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.