sqlcmd how to output errors when calling from batch file

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  July 18, 2008 at 11:31 am

  #194079

  :Out in sqlcmd equals to -o from command line

  Whats the same equal variable for :Error ?

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA

• Gordon-265412

  SSCrazy

  Points: 2898

  More actions

  July 18, 2008 at 3:09 pm

  #845273

  -r

  From BOL under "SQLCMD"....

  -r [ 0 | 1 ] msgs to stderr

  Your friendly High-Tech Janitor...

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  July 31, 2008 at 5:48 pm

  #851597

  Has anybody used -r flag, i coudn't find any method to use it though...

  and no pointers on google also to use this error trapping method....

  any help appriciated....

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA

• Prakash Heda

  SSCertifiable

  Points: 5539

  More actions

  July 31, 2008 at 6:05 pm

  #851602

  Finally worked....

  sqlcmd -E -i"install.sql" -r1 2> install-err.log 1> install.log

  Thanks Gordon....

  Prakash Heda
  Lead DBA Team - www.sqlfeatures.com
  Video sessions on Performance Tuning and SQL 2012 HA