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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
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
 
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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
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
 
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 & ArchitectCommented:
>> 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
 
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
All Courses

From novice to tech pro — start learning today.