Question:
I have a text field in a table that returns the entire field when queried. As soon as I create a view in SQL Enterprise Manager though, the text is truncated immediately after the colon(:) and returns only the first part of the text message.
How do I have it return the entire text field?
Answer:
In Query Analyzer with version 7 and above, bump up the “maximum characters per column” setting. I believe it is set to 256 by default.
In SQL 2000, you can find this option under tools, options, and the results tab. Because I don’t have version 7 handy right now, I can’t tell you the exact place to change the setting in 7, but it is there too.