By default, SQL Query Analyzer only displays the first 256 characters for each column's value. Follow these steps to display up to 8192 characters per column:
From the SQL Query Analyzer menu, select Tools -> Options:
On the Results tab, use the “Maximum characters per column” field to specify the maximum number of characters to display in an output column:
This value can be between 30 and 8192.
Note: This setting also affects the behavior of the Transact-SQL Debugger window.
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.