• Create a batch file (.bat) that uses the SQLCMD command with the list all of the scripts required. The file contents would be similar to below.

    SQLCMD -S "servername" -d "databasename" -E -i "<PATH>\sqlfile1.sql" -o "c:\temp\sqlfile1.txt"

    SQLCMD -S "servername" -d "databasename" -E -i "<PATH>\sqlfile2.sql" -o "c:\temp\sqlfile2.txt"

    Of course, the order of the scripts is important!

    You could create the .bat file by iterating through the files in a directory and plugging the file name into the appropriate places and saving the file to disk.

    Thanks...Chris