Determines whether TDS debugging information appears in the database server messages window.
On, Off
Off
PUBLIC role | For current user | For other users | |
---|---|---|---|
Allowed to set permanently? | Yes, with SET ANY PUBLIC OPTION | Yes | Yes, with SET ANY PUBLIC OPTION |
Allowed to set temporarily? | Yes, with SET ANY PUBLIC OPTION | Yes (current connection only) | No |
When the database server is started with the -z option, debugging information appears in the database server messages window, including debugging information about the TDS protocol.
The suppress_tds_debugging option restricts the debugging information about TDS that appears in the database server messages window. When this option is set to Off (the default) TDS debugging information appears in the database server messages window.