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?
David S. Alexander
Kettley Publishing
20271 SW Birch Street, 2nd Floor
Newport Beach, CA 92660-1752