Why do I only get 255 characters back in a column in Query Analyzer?

A. The 255 limitation is a Query Analyzer option - you can change it - or use OSQL.EXE which won't show this limitation.

Go to Query/Current Connection Options/Advanced and change max chars per column to whatever maximum you desire.


Hide comments

Comments

  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
Publish