OSQL command problem

• Raxit Shah

  SSC Rookie

  Points: 41

  More actions

  June 22, 2004 at 12:06 pm

  #161737

  Hi guys,

  I am facing a problem using an OSQL command.

  I am trying to store the output of the procedure in a file.

  The command that i am writing is as follows

  OSQL /U Username /P password /d VHR_DATASQL /S SQLSRV1   -s""  /Q "exec procedure_name"  -o  C:\AMEX.dat

  however the output that it is generating ( size of the file ) is 100 times larger

  than the file ...that is expected. The file size it creates is @ 300 MB .

  please let me know where i am going wrong.

  Thanks,

  Raxit

   

   

   

• martin bigi

  Newbie

  Points: 6

  More actions

  June 22, 2004 at 1:00 pm

  #511502

  why "/" and "-"  in the line?

  remove   -s""   (default spacing) .