Jim,

Are you running the query in the SQL Server Query Analyzer?

If it is, Go to Tools Menu and select "options". In the "options" window go to "Results" tab and increase the "Maximum characters per column:". The default is 256.


Rene

>I used sql profile and save the result in a table. In this table a column called Textdata stored all query text. I used 'select textdata from table'. But I can't see all text for long query, it only show begining of query. The textdata is ntext data type and can put lots charters.
>
>How can I see all content in this column?
>
>
>Thanks
>
>
>Jim