There is a Colmn with data type "ntext" with length 16 in a table.
when i select data for this column in Query Analyzer(QA), i can only see 256 characters cuz its default.
i can change this value to max 8192 char in options -> results.
but what if i want to see data more than 8192 char in QA?
I tried to save in text and export to excell /access but i can get only max 8192.
some times i need to check the whole big string and its tidious to call them in a front end page.
anyone knows how to solve this???