Feature Request: RollBack on script Failure

Single-click script execution on multiple SQL Servers.

Moderators: JonathanWatts, Anu Deshpande, dlkj, Colin Millerchip, Michelle Taylor

Feature Request: RollBack on script Failure

Postby vlitim » Thu Sep 24, 2009 11:31 am

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.

cheers
vlitim
 
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 1 guest