Toad World® Forums


If I have multiple rows of
exec sp_name some_params

and I try to execute the entire script.

if it fails on line 100 - will it commit the 99 previous lines or unless
everything succeeds it rolls back ?


if you need to not commit then:
Wrap your script into transaction
Turn on option “autocommit off for current editor” - you can see it in the status bar at the left bottom corner. Remember - you will need to commit transaction manually or you will be experiencing locks.