One of the very simple and common that one of the commenter asked me a few days ago was why does the SQL query analyzer show only results unto 255 character only and not full column text. This is common to any data type in SQL server Query Analyzer.
The maximum number of character displayed using the tools->Option menu. Go to the result Tab and change the ‘Maximum characters per column’. BY default the value is set to 255. The maximum value allowed here is 8192 character.
In SQL Management studio (for SQL server 2005) go to Tools->Options, expand Query Results / SQL Server / Results to Text, and change the setting for “Maximum number of characters displayed in each column.. Note that in Results to Grid, you can send 65,535characters; however, results to text is still limited to 8,192 character only