• I do this all of the time using two batch files. The first one contains a %1 value for the server name, similar to below:

    run.bat:

    sqlcmd -S %1 -E -i "X:\script.sql" -o "X:\%1_scriptout.txt"

    The second one then calls this one passing in the name of the server as a parameter:

    DeployAllServers.bat:

    call run.bat auca-sql02

    call run.bat auca-sql01

    call run.bat auca-sql01

    I use it to deploy the same scripts to dozens of servers at a time and it works pretty well for that.