August 29, 2007 at 3:03 am
I have a table with a varchar(1024) field. When I view a record that I know has 619 characters in this field - (the len function also cofirms this) query analyzer only displays 256.
If I look at this record in enterprise manager I can view the full text.
Why is this and what are the limitations when using query analyzer?
August 29, 2007 at 3:06 am
Go to Tools->Options->Results->Maximum Characters per column, and set it to a higher number.
Regards,
Andras
August 29, 2007 at 3:07 am
Because you rarely need to view such long strings whole, the default setting of QA is to display 256 characters.
You can change this in Tools>Options>Results>Maximum characters per column.
August 29, 2007 at 3:12 am
Great - thanks both I have never came across that option before.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply