OSQL Supress Row Count?

• texpic

  SSCertifiable

  Points: 5887

  More actions

  December 23, 2005 at 9:15 pm

  #188752

  EXEC master..xp_cmdshell 'osql -U______ -P______  -Q"select * from MyTable" -dAutoMail -h-1 .set NOCOUNT -oc:\output.txt', no_output

  I'm using this to output data from a table into a txt file.  Works fine, except I get the row count.

  Is there a parameter or something I can add to supress the row count.  I used -h-1 to get rid of the headers.

   

  Thanks 

• texpic

  SSCertifiable

  Points: 5887

  More actions

  December 23, 2005 at 9:31 pm

  #611378

  I was close, figured it out.

   

  EXEC master..xp_cmdshell 'osql -U______ -P______  -Q"SET NOCOUNT ON select * from MyTable" -dAutoMail -h-1 -oc:\output.txt', no_output