SQL Multi Script - 1.1
Learning SQL Multi Script - 1.1
About script execution
This topic describes the order in which SQL Multi Script executes scripts against a list of databases. This information can be useful to help you decide how to use the settings available to control how SQL Multi Script executes scripts.
SQL Multi Script executes scripts in the order you have set up in the list in the Scripts to Execute pane. It waits for each batch in a script to finish executing before it executes the next batch. When all the batches in a script have been executed against a database, SQL Multi Script executes the next script against the database.
If you are executing scripts against more than one database, the order in which scripts are executed depends on whether you have set the Optimization option to Serial execution or Parallel execution.
- With Serial execution, SQL Multi Script executes all the scripts against one database. When the scripts have been executed against the first database, SQL Multi Script executes all the scripts against the next database, and so on until all the scripts have been executed against all the databases.
- With Parallel execution, SQL Multi Script executes the first script against each database in your list. When a script has been executed on a particular database, SQL Multi Script executes the next script against that database. This means that results for different databases may be returned at different speeds.
- If you choose Parallel execution and you set the Databases to execute against simultaneously option to a number that is the same as or greater than the total number of databases that you are executing scripts against, SQL Multi Script executes all the scripts simultaneously.
- If you choose Parallel execution and you set the Databases to execute against simultaneously option to a number that is lower than the total number of databases that you are executing scripts against, SQL Multi Script executes all the scripts against the maximum number of databases you have set, then as soon as execution against one of the databases is complete, it starts executing the scripts against one of the remaining databases.
You can see the progress of results being returned for each script and for each database on the Results pane.
About parsing scripts
SQL Multi Script parses scripts in the same order as it would execute them, and displays information and errors in the Results pane.
About cancelling script execution
If you manually cancel script execution or parsing (for example, by clicking Cancel) or you exit SQL Multi Script while scripts are being executed or parsed, SQL Multi Script stops executing scripts against all databases.
See Also |
Was this article helpful?
Getting startedSQL Multi Script
- Migrating database lists between users and computers
- SQL Multi Script v 2008 multi server functionality
all SQL products
- Compatibility of Red Gate tools in 64-bit environments
- Application has encountered an error and needs to close
- Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
- Changing the temporary directory used by the installer
- Toolbelt Installer "hanging" while "scanning volumes"
- Login failing with "trusted SQL Server connection" error when using RunAs
all products
- Some Red Gate products identified as containing a trojan by Anti-Virus software
- Activation may fail with Unknown Error -1
- Product uses web help although a CHM file is available locally
- Argument exception resulting from missing environment variable
- Check for updates may fail when used through proxies
- 'Unidentified Publisher' error when repairing or uninstalling
- Licensing activates product as standard edition
- Moving Red Gate software products to another machine
- Red Gate tools log locations
- The application UI opening slowly when there is no internet access
SQL Multi Script
all SQL products
all products
- Red Gate product acknowledgements
- Activating your products
- Activating your products
- Red Gate bundle history
- Check for updates
- Troubleshooting Check for Updates errors
- Current versions
- Deactivating your products
- Installing Red Gate products from the .msi file
- Requesting additional activations
- Serial numbers for bundles
- Reactivating using a different serial number
- Extending your trial
- Finding your serial numbers
- Moving a serial number from one computer to another
- No response received for manual activation
- Licensing and activation resources
- Licensing and activation resources
- Troubleshooting licensing and activation errors
- Licensing and activation FAQs
- Red Gate tools log file locations
- Download old versions of products
- Download product prerequisites & utilities
- Support & upgrades
- Upgrading your software
- Upgrading FAQs
