on my machine at home i can run this command without problem
sqlcmd -S UCHOOSEWEB\SQLEXPRESS -i C:\TRANSFORMTVDATA.SQL -O C:\OUT.TXT
a console window appears and displays messages such as 'changing database context" and '-o is obsolete' and the sql in the file is executed
if i run the same command on my web server a console window opens and the closes immediately. It seems like there is something wrong with the sqlcmd on the web server. Naturally i am using the appropriate machine names on the different computers.
If i type sqlcmd -S UCHOOSEWEB\SQLEXPRESS a console window opens with '>1' as a prompt.
why cant i run the command on the web server?
thanks a lot