Excellent! Thanks for the prompt (and useful) replies. I went with option 2 and used the SQLCMD which has worked a treat.

Is it possible to loop SQLCMD so that the defaultserver variable could be updated each time from a table of server names?