loop that executes all .SQL files in a folder

Question

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply

manojkanoi SSCrazy Points: 2292 More actions · Answer 1

Thank you very much. This was very helpful and informational.

scott.gach-667672 SSC Journeyman Points: 98 More actions · Answer 2

Is there any way to break out of the loop if one of the scripts fails?

akruwala.work Grasshopper Points: 11 More actions · Answer 3

Grasshopper

Points: 11

April 22, 2011 at 4:35 am

nice forum...

great help!!!!

David Burrows SSC Guru Points: 65144 More actions · Answer 4

scott.gach-667672 (2/2/2009)
Is there any way to break out of the loop if one of the scripts fails?

Add -b parameter, check ERRORLEVEL and use GOTO after each file is processed may do the trick.

Far away is close at hand in the images of elsewhere.
Anon.

Cookies on SQLServerCentral