• Thank you,

    I added the

    RAISERROR('Script Failed!', 20, 1) WITH LOG

    and it closed the connection preventing subsequent scripts from running!