 |
|
8000XXXX Errors Alerts ASP.NET 2.0 Classic ASP 1.0
Databases Access DB & ADO General SQL Server & Access Articles MySQL Other Articles Schema Tutorials Sql Server 2000 Sql Server 2005 General Concepts Search Engine Optimization (SEO)Search
ASP FAQ Tutorials :: Databases :: General SQL Server & Access Articles :: Why is Query Analyzer only returning 255 characters?
Why is Query Analyzer only returning 255 characters?
SQL Server's Query Analyzer tool is limited, by default, to display 255 characters of any column (regardless of datatype).
SQL Server 2000
To expand this a bit, you can go to QA's Tools / Options menu, move to the results tab, and adjust the 'Maximum characters per column' field. The maximum length of the output for any column is 8,192 characters; if you need more, consider another application to view the data.
SQL Server 7.0
Go to the Query menu, Current Connection Options. On the Advanced tab, change the value for 'Maximum characters per column.'
SQL Server Management Studio (SQL Server 2005)
Go to Tools / Options, expand Query Results / SQL Server / Results to Text, and adjust the setting for "Maximum number of characters displayed in each column:". Note that in Results to Grid, you can send 65,535 characters; however, results to text is still limited to 8,192.
SQL Server 2000
To expand this a bit, you can go to QA's Tools / Options menu, move to the results tab, and adjust the 'Maximum characters per column' field. The maximum length of the output for any column is 8,192 characters; if you need more, consider another application to view the data.
SQL Server 7.0
Go to the Query menu, Current Connection Options. On the Advanced tab, change the value for 'Maximum characters per column.'
SQL Server Management Studio (SQL Server 2005)
Go to Tools / Options, expand Query Results / SQL Server / Results to Text, and adjust the setting for "Maximum number of characters displayed in each column:". Note that in Results to Grid, you can send 65,535 characters; however, results to text is still limited to 8,192.
Related Articles
Can I fix this mm/dd/yyyy <-> dd/mm/yyyy confusion once and for all? Could I get some help with JOINs? How can I tell which version of MDAC I'm running? How do I access MIN, MAX, SUM, COUNT values from SQL statements? How do I change column order in a table structure? How do I change the order of columns in a table? How do I concatenate strings from a column into a single row? How do I convert columns of values into a single list? How do I determine if a database exists? How do I document / compare my SQL Server database(s)? How do I get the IDENTITY / AUTONUMBER value for the row I inserted? How do I solve 'ADO Could Not Find The Specified Provider'? Should I use BETWEEN in my database queries? Why can't I use the * wildcard in a database search? Why do I get 'Syntax Error in INSERT INTO Statement' with Access? Why do I get weird results when using both AND and OR in a query? Why do some SQL strings have an 'N' prefix? Why does AbsolutePosition return as -1? Why doesn't SQL Server allow me to separate DATE and TIME? Why should I avoid NULLs in my database? How do I deal with an apostrophe (') in a SQL statement?