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
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