set_trace

The set trace stored procedure is used to enable special debug tracing to the oasErrlog.log file. It is a different type of tracing than the debugging enabled by the ToggleDebug tool. The trace commands are toggles. They should be called once to turn on the debug tracing, and a second time to turn the tracing off.

call set_trace(<command>)

Where <command> is one of the following (which are not case-sensitive):

• Microsoft SQL: Logs the text of the Microsoft SQL commands which are executed and the amount of time it takes to execute. Inner and outer joins of a Microsoft SQL command will log two (or more) messages to the log.

• CONNECTIONS: Logs a message when a user connects or disconnects from the Microsoft SQL Engine.

  call set_trace('SQL');

  call set_trace('CONNECTIONS');