title: How can I set the maximum number of characters per column using sqlcmd?
body: <p>While using SQL Server Management Studio, I generally do:</p>
  
  <pre><code>Query-&gt;Query Options-&gt;Advanced-&gt;SET NOCOUNT
  Query-&gt;Query Options-&gt;Text-&gt;Enter 8000 in the lower right box
  </code></pre>
  
  <p>Can someone please tell me if there is anyway I could do this using <code>sqlcmd</code>?</p>