Is there a setting in Enterprise Manager that controls whether <long text> displays

We're still using SQL 2000 (transitioning to 2005 soon).

In Enterprise Manager I used to see the phrase <long text> when a field contained a great amount of text. I know this is a function of Enterprise Manager and we built a form so we could see and edit that text.

However now I'm just seeing a blank field when the amount of text exceeds EM's limits. When we put that field into a web page all the text displays fine so we know the text is being stored. However it's a bit scary not seeing anything in the field now.

Would this be something controlled by the SQL Server Administrator (a DBA)?

skeddy136Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LowfatspreadCommented:
ubder the latest versions of sql server you can specify how much "long text" is retrieved/display in "EM". I can't remeber if that was the case in 2000....

have a look under QUERY (or OUTPUT) in Query Analyser and see if there is a limit you can set...

hth
0
David ToddSenior DBACommented:
Hi,

Query Analyser and SSMS have a setting to control how much of long fields is shown.

I looked just now in Enterprise Manager, and couldn't see anything similar.

Suggestion: Query the table in Query Analyser and you should see at least the start of this field.

Or has the field changed from varchar( 8000 ) to text?

Sorry I can't be more help
  David
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
You can't do it in Enterprise Manager ( aimed for Administrative/Management purposes).
Able to do it only in Query Analyzer or SSMS because they are client tools.
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

skeddy136Author Commented:
Thank you all.  I indeed can see the contents of the field in Query Analyzer and in SQL Management Studio.  

However my question is --
why, at one time, would I see the phrase <long text> displayed in the field in Enterprise Manager and now I'm only seeing a blank field.

Is it possible applying a Service Pack to SQL Server 2000 made this change?

And please forgive my naiveity - this may be a moot question due to the demise of Enterprise Manager anyway.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> why, at one time, would I see the phrase <long text> displayed in the field in Enterprise Manager and now I'm only seeing a blank field.

Are you sure you have data for that particular column & row available both the times..
If it is NULL, then you would be seeing a blank field.

>> Is it possible applying a Service Pack to SQL Server 2000 made this change?

Applying SPs would not impact in this way unless otherwise some bugs are resolved out..
For Microsoft products as recommended, stay upto date with latest Service packs and hence apply SP4 for SQL Server 2000.
0
skeddy136Author Commented:
There is data in the field since when we display the field in a web page you can see the text there. Also using a web application to edit the field brings up the text and we can edit the text.

Additionally I've tried deleting the text so it is shorter in length and when it is made shorter, we can then see it in Enterprise Manager.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Kindly make sure that

* data in that particular column is not encrypted.
* Tab and New line character in the field / column might also cause this..
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
skeddy136Author Commented:
All other records in that table show data in that column so I wouldn't think it is encrypted.

I really don't want anyone, (esp. you rrjegan17) to spend more time on this as we are upgrading to 2005 where this is no longer a question since we will not be using Enterprise Manager.

So will accept the solutions above.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.