Justin,

Thanks for the suggestion. It fixed the problem in Query Analyzer, but not Enterprise Manager. I am going to try updating SQL Server, since I am only running SP-1, but other people here who don't have this problem are running the same Service Pack. I guess as far as SQL is concerned, long text fields are only displayed on a "need to know" basis and I don't need to know enough.

Thanks.


>Hey David :)
>
>Open up the table in Query Analyzer, then go to Tools, Options, Results, and change the 'Maximum Characters Per Column' from 256 to 2500.
>
>That will fix the display in QA - not sure about EM though.
>
>-Justin
>
>>I am having a strange quirk when I am using SQL Enterprise Manager on my workstation.
>>
>>What I want to do is view rows in a table and manually edit them. The problem is that longer values are not displayed, despite being populated. The column is of type varchar(2500). If I log onto our network using the same account on another terminal and run SQL Enterprise Manager, I can view them.
>>
>>I have been editing them by pulling them in C# code in VS.NET, copying them out of the watch window, and pasting them into an update statement in Query Analyzer, which is inefficient.
>>
>>I couldn't find a preference or option setting that seemed to control this, but since it is limited to my workstation, it must be bad bits in my black box.
>>
>>How can I change this display behavior?