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 ?
Thanks,
Dani
if you need to not commit then:
Wrap your script into transaction
or
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.