Using the Debugging Facility

SQL Output

A debugging facility is available from the tsmssql process. The debugger is activated by either setting the registry entry DEBUG-LEVEL or starting the Manager service with a –dn parameter.

n

Currently the only debug level is 1. This sends the generated SQL statements to the log file (tsmssql.log). The output in the log file contains a separate line for each generated SQL statement.

While debugger

is active, output for all clients connected to the same SQL Server Group is sent to one

tsmssql.log file.

If the tsmssql.log file is copied, output will continue to be placed in the renamed file until the Basic session is terminated. All subsequent Basic sessions would then use a new debug log.

From the TS DataServer for MS SQL Server, version 8.9.1. Open this page in the PDF