itmasterw 60042 wrote:
@Jeff - Server is optional - if not supplied it run on the local machine where bcp is executed and connects to its default instance.
But doing this is bad practice and should be avoided
Agreed... that's why I stated it the way I did. I've seen enough people (including myself in the early days) have issues that I don't consider it to be optional and didn't want the OP to think it was. He's also going to need to cite which database he wants the code to run in or make the possible mistake of using 3 part naming, as well, for the same reason... defaults change.