SQLCMD Output vs SSMS Output

• hindle.steve

  SSCrazy

  Points: 2057

  More actions

  February 23, 2012 at 2:37 am

  #251946

  I have been executing multiple SQL scripts using a batch file with SQLCMD and outputting the results to a text file.

  What I have noticed is that the output differs between using the -o and -r parameters. Also if I run the scripts manually in SSMS the output is different again.

  For example;

  sqlcmd -E -s ServerName -d DBName -i Script1.sql -r > C:\Output\output.txt

  sqlcmd -E -s ServerName -d DBName -i Script2.sql -r >> C:\Output\output.txt

  as opposed to

  sqlcmd -E -s ServerName -d DBName -i Script1.sql -o > C:\Output\output.txt

  sqlcmd -E -s ServerName -d DBName -i Script2.sql -o >> C:\Output\output.txt.

  Has anyone seen this before?

  Thanks

  Steve

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  February 23, 2012 at 5:07 am

  #1450768

  What is the difference in your outputs?

• hindle.steve

  SSCrazy

  Points: 2057

  More actions

  February 23, 2012 at 6:10 am

  #1450790

  The -o / -r switched gave different levels of detail. The output from running manually in SSMS was different again.