Tracing can be done on the entire script or on a section of the script. To trace the entire script execution, put the TRACE ON statement in the BEGIN statement. To trace only a section of the script, put the TRACE ON statement in the script where tracing should begin and put the TRACE OFF statement where tracing should end. See TRACE OFF for additional information on turning tracing off.

This statement turns tracing off. This means that trace information will no longer be logged into the log file while the script is executing. The TRACE OFF statement is only valid if a TRACE ON statement has been defined previously in the script. See TRACE ON for additional information on tracing.