View Execution Log Messages

Editor and Query Builder Windows

When you execute SQL in the Editor or the Query Builder, a log of executed commands displays in the Messages tab.

Note: The Messages tab only clears when you execute a full script. If you execute a partial script multiple times, each execution displays in the tab.

Tips:

To jump to the line of code associated with the executed command, double-click the line with the executed command.
To switch between the grid and a text view of the output, right-click the Messages tab and select Text Output. This is useful when using PRINT statements.
To re-execute a statement, right-click the statement in the Messages tab and select Re-execute.
If you occasionally closed the Results pane, you can restore it by selecting Editor | Windows | Script Results.

Automation Window

When you execute an Automation script, the execution log displays in the Log tab of the Automation window. See Execute and Schedule Automation Scripts and Automate Tasks for more information about Automation scripts.

To troubleshoot errors encountered when executing scheduled Automation scripts, see Troubleshooting Scheduled Automation Scripts.

Tip: To switch between the grid and a text view of the log, right-click in the Log tab and select Text Output.

Output Window

You can use the Output window (View | Output) to view logs and messages from different sources. See View Output Window for more information.