General information
Forum:
Microsoft SQL Server
Category:
Database management
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only