I have a question about the behaviour of SQLCMD vs the behaviour of the Management Studio's handling of the same operation. In the Management Studio multiple executions of the indicated line in the attached File result in multiple lines of output showing:
(1 row(s) affected)
If SQLCMD is used to run the identical stored procedure, with the identical results occuring in the database, only the first running of EXEC (@FixInstruction) results in visible output, and subsequent executions result in the desired data changes, but no visible output. Is there an option for SQLCMD which will correct this?
This is SQL Server 2005 (9.0.5057) running in Server 2008 SP2, with Management Studio 9.00.5000.00 and SQLCMD 9.00.5000.00 NT INTEL X86.
I would appreciate any suggestions.