Displaying Longer Results in SQL Query Analyzer

Provided by Molly Pell, Senior Systems Analyst

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.

Additional Resources



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.

Darren D.

View all FMS products for Microsoft Access All Our Microsoft Access Products



Free Product Catalog from FMS