How can we help you today? How can we help you today?

Abort Script if Error Found?

When the generated SQL script encounters an error, it does a rollback and continues executing the script. Can it instead rollback and stop any following commands from executing via something like SET NOEXEC ON?
JYoder
0

Comments

2 comments

Sort by
  • denisgil
    You can Do:

    SET NOEXEC OFF

    Then on Error:

    @TRANCOUNT>0 ROLLBACK SET NOEXEC ON END
    GO


    If first taught you had some other error management but after I review it, no magic... maybe you have a reason behind... If so, Pls share...
    denisgil
    0
  • JYoder
    Yes, that's if I did it myself. I'm asking if SQL Compare can generate it's output scripts in a similar fashion.
    JYoder
    0

Add comment

Please sign in to leave a comment.