sql server (alternate):
I am trying to view all the ntext from a profiler trace. The data is
truncated at 256 and I am not sure why... The max length is 1820 via
this command:select max(datalength(textdata)) from "monitor forms usage"
where textdata like '%gforms%' .

I then issue
set textsize 8000
select (textdata) from "monitor forms usage" where textdata like
'%gforms%' and datalength(textdata) >1800

and still only 256 is returned. this is true even if I redirect the
output to a file.

Any ideas on how a humble man like me can see all of the data.

Mike

--

wukie (member30544@dbforums.com) writes:
[quoted text, click to view]

I guess you are using Query Analyzer. Tools->Options->Results, and
where you see 256 change it to what you want.


--
Erland Sommarskog, SQL Server MVP, sommar@algonet.se

Books Online for SQL Server SP3 at

that was it. Thanks!

--