Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I determine what happens if an error occurs upon execution of a script?

April 26, 2017determine Error execution happens occurs Script

0

Posted

Can I determine what happens if an error occurs upon execution of a script?

1 Answer

0

Posted

Yes. From the On Error drop-down menu above the Database Distribution List, you can specify how you would like SQL Multi Script to behave if there is an error during execution. There are four options: (1) SQL Multi Script can continue executing the script. (2) SQL Multi Script can skip the script on the database that contains the error (but will continue to execute the next script in the list for that database. Script execution against all other databases in the distribution list that do not contain an error remains unaffected). (3) SQL Multi Script can stop executing the script on the database with the error. SQL Multi Script will also stop execution of any further scripts for that particular database (but it will continue to execute scripts for other databases that do not contain the error). (4) SQL Multi Script will stop executing all scripts on all databases.