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:

Enterprise Manager causing extensive network traffic

Does anybody have any idea what is happening here. On 3 out of five workstations when entering Enterprise Manager the network traffic jumps drastically to the point that the server needs to be rebooted. Any information would be greatly appreciated.
Thanks
NewbieTry Using the SQL Profiler that comes with SQL Server

This underused programme will list every command that hits the SQL Server in Real time.

Just run the default trace & see whats happening when a client logs on

GW|||I used profiler this morning, using the default trace and I also set it to log everything. It didn't log anything out of the ordinary, and there was nothing that coincided with the amount of traffic being generated.

Originally posted by GWilliy
Try Using the SQL Profiler that comes with SQL Server

This underused programme will list every command that hits the SQL Server in Real time.

Just run the default trace & see whats happening when a client logs on

GW|||OK

My next step would be to download a trial version of Commview 3 - install it onto the client.

This App is an excellent packet sniffer and will show you exactly any traffic that is happening & to which IP Address it is going to

You could try and decipher the packets with this tool if you are brave - at very least it will show how much traffic is generated on which port to where.

GW