SQL Multi Script - 1.1

SQL Multi Script

Learning SQL Multi Script - 1.1

Viewing results

When you execute or parse scripts, SQL Multi Script displays the results in the Results pane.

To display more results on the screen at one time, click to float the Results pane, then you can resize the pane.

Messages

SQL Multi Script creates a single Messages tab for each script that it parses or executes, containing information such as error messages, warnings and any textual output from the scripts.

Results

SQL Multi Script creates a Results tab for each result set that a script returns. In the example above, the script contained two Select statements, so there are two Results tabs.

Viewing feedback on script execution and parsing

When you execute or parse a set of scripts, they are added to the top of the Scripts Executed list and labelled with a timestamp that indicates the time that SQL Multi Script started executing or parsing.

  • To see the results for a particular script, select the script in the Scripts Executed list.
  • To see the results for the selected script on particular databases, use the check boxes in the Executed Against list to select the databases you are interested in and to hide the results for other databases.

Icons in the Scripts Executed and Executed Against lists indicate whether script execution or parsing was successful:

Execution or parsing was successful.

Execution or parsing was cancelled, so the script was not executed or parsed. This icon is shown if you stop execution or parsing manually (by clicking Cancel) or if execution was cancelled because there was an error with executing part of a script and the On error setting is set to stop execution in this situation. See Executing scripts for more information on how to stop execution and how to change the behavior if there is an error during execution.

There was an error executing part of a script or there was a parse error in the script.

In the Scripts Executed list, these icons give you summary information about execution of scripts against multiple databases. If there are any errors in the set of scripts or for a particular script against a set of databases, the icon is displayed, regardless of whether some scripts were cancelled or were executed successfully. If there are cancellations, but no errors, the icon is shown. In the Executed Against list, these icons tell you about execution against particular databases.

Some examples:

  • In the screenshot above, the icon next to 3 scripts executed at 11:18 indicates that there was an error with execution of at least one script against at least one database. As you can see from the screenshot, although there was an error with script2.sql, script1.sql executed successfully, and script3.sql was cancelled.
  • In the screenshot above, the icon next to script2.sql in the first set of scripts indicates that execution was cancelled against at least one database. As you can see from the Executed Against pane, the script executed successfully against RECORDS.master.
  • In the screenshot above, the icon next to TEST.master indicates that execution against this database was cancelled. Execution against RECORDS.master was successful.

Saving results

You can save results and messages in either CSV or TXT format.

  • To save results or messages in CSV format, display the result set or messages, select Grid from the Display list, then click Save.
  • To save results or messages in TXT format, display the result set or messages, select Text from the Display list, then click Save.

See Also

Executing scripts

Worked example

Was this article helpful?

Search support
Forums
Visit the SQL Multi Script forum.
Learning SQL Multi Script
Knowledge base

SQL Multi Script

all SQL products

all products

Notes & articles

SQL Multi Script

all SQL products

all products

Demos & walkthroughs

SQL Multi Script