Does SQLCmd step support atomic transaction?

The above step, if I have multiple scripts in the “SQL Files” field, are they going to be run in an atomic transaction? Means in either all occur, or nothing occurs. e.g. if there are 5 scripts, and fails on the 3rd, then 1&2 won’t be committed?


Leave a Reply