Thanks for the great info again, just a couple of questions on this.
Will the :eof in either of these close the batch file or just signal the end of that action? from what i've read i believe it ends the batch file but still a little unclear.
I want to call the errormsg batch file should all attempts at connecting to the database fail, is it possible to incorporate?
I should point out that in the example of what i was using above the full batch file did have EXIT at the end to close it once complete.