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

Running multiple compare scripts in sequence within app.

Hi Chiefley,

It looks like you could do what you need to do by commenting out the COMMIT TRANSACTION at the end of the first script and also the BEGIN TRANSACTION near the top of the second script. This should get both scripts together as one transaction that will only commit if both scripts run successfully.

It will also cause the ROLLBACKs to affect both scripts as well.

You'd want to concatenate the script files into one unless you can run both script files through the same connection to the SQL database.
Brian Donahue
0

Comments

1 comment

Sort by
  • Brian Donahue
    Hi,

    That should do it. As long as the connection stays open, the server should only commit the transaction when it gets the COMMIT TRAN from the final script, provided there is a BEGIN TRAN at the top of the first script.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.