The forum will be unavailable for maintenance at some point from Friday, April 13 at 19:00 EDT until Sunday, April 15 at 23:59 EDT. Downtime will be minimized but the exact timing is unknown.

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's gravatar image

accept rate: 0%

edited 15 Mar '13, 21:04

Mark%20Culp's gravatar image

Mark Culp

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

permanent link

answered 07 Dec '12, 04:13

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

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.

permanent link

answered 07 Dec '12, 06:05

Thomas%20Duemesnil's gravatar image

Thomas Dueme...
accept rate: 17%


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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 07 Dec '12, 03:38

question was seen: 1,055 times

last updated: 15 Mar '13, 21:04