Is it possible to get output from scripts while they run? I have a script that generates a bunch of tables with PRINT and GO statements in between. I'd like to see the output from the PRINT statements while the script is running.
Run the script with SQLCMD.EXE and you'll be able to see the output as it is generated.
The GUI tools cache the output, so you don't see anything until the tool is ready to show it to you which is often after the script completes (don't get me started on this design decision, you really don't want to know what I think of it)!
No, CMD.EXE executes the commands in a pipe sequentially instead of concurrently. That means that youi can achieve a similar effect to the Unix tee (echoing to both stderr and stdout) but the tee executable won't run until after the previous executable finishes, so the output won't be displayed while the first program is running.