Enterprise Manager field > 900 chars not displaying post SP4

I think this started happening post SP4.
I have an nvarchar(4000) field. If I query the table in Enterprise Manager,
the data for the field only displays in rows where the value is 900 chars or
less. Otherwise, the field looks empty, but when I click in it and type, I
get a popup that says "Cannot edit this field."
I can query the data, so I know it's there, but it's annoying not to see it
in the results.
Has anyone else noticed this?
<Cliff>
Enterprise Manager is not meant to be a data editor. May I suggest that you
use Query Analyzer (and Transact-SQL statements to edit the data)? The
other option is to create a GUI that you can use to edit the data within
your databases.
Keith
"Cliff Morrison" <CliffMorrison@.discussions.microsoft.com> wrote in message
news:3C026C09-A968-466A-B1D0-FAE7EC4EACE5@.microsoft.com...
>I think this started happening post SP4.
> I have an nvarchar(4000) field. If I query the table in Enterprise
> Manager,
> the data for the field only displays in rows where the value is 900 chars
> or
> less. Otherwise, the field looks empty, but when I click in it and type,
> I
> get a popup that says "Cannot edit this field."
> I can query the data, so I know it's there, but it's annoying not to see
> it
> in the results.
> Has anyone else noticed this?
> <Cliff>
|||I'm not really trying to edit. The only reason I did in my example was to
show that something strange was happening with the field.
I do think I should be able to visually verify in Enterprise Manager query
results that data is in a field, regardless of whether that data is less than
or equal to 900 characters in length.
<Cliff>
"Keith Kratochvil" wrote:

> Enterprise Manager is not meant to be a data editor. May I suggest that you
> use Query Analyzer (and Transact-SQL statements to edit the data)? The
> other option is to create a GUI that you can use to edit the data within
> your databases.
> --
> Keith
|||I am having the same problem, except it is happening with text fields and a
char(1024) field. Shorter fields and a varchar(4096) field seem to show up
just fine. EM used to display the data in these fields before I upgraded to
SP4. What is going on?
Rob
"Cliff Morrison" wrote:

> I'm not really trying to edit. The only reason I did in my example was to
> show that something strange was happening with the field.
> I do think I should be able to visually verify in Enterprise Manager query
> results that data is in a field, regardless of whether that data is less than
> or equal to 900 characters in length.
> <Cliff>
> "Keith Kratochvil" wrote:
>
|||Or check out AgileInfoSoftware DataStudio for editing data. You can directly
update table content, and there is no known limit for the length of
character.
John King
http://www.agileinfollc.com
"Rob Drollinger" <RobDrollinger@.discussions.microsoft.com> wrote in message
news:993820FF-C681-4E34-8344-BBC28C8CF008@.microsoft.com...[vbcol=seagreen]
>I am having the same problem, except it is happening with text fields and a
> char(1024) field. Shorter fields and a varchar(4096) field seem to show
> up
> just fine. EM used to display the data in these fields before I upgraded
> to
> SP4. What is going on?
> Rob
>
> "Cliff Morrison" wrote: