Single-click script execution on multiple SQL Servers.
Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor
At the moment seems that when an error occurs all you can do is stop executing. If this happens you are pretty much left in the lurch trying to pick through your scripts and start the process up again half way through a script, all the time the dbase you are tunning against is now half updated.
You really need to be able to execute all the scripts within one transaction so that any failure within any of the scripts rolls the dbase back to its previous state.
- Posts: 1
- Joined: Thu Sep 24, 2009 11:25 am
Return to SQL Multi Script 1
Who is online
Users browsing this forum: No registered users and 0 guests