sql server 2000 shows <long text> instead of actual content

[DoubleV]

I did data transfer from MySql to SqlServer 2000. In MySql the field was of type text and I have specified the field to be of the same type in SqlServer. But now in SqlServer (via Enterprise Manager) all I see is <Long Text> instead of teh actual content and I cannot view or modify it. I can modify it via an sql statement. If I change the content to be something short, then I can select and modify text via the table view instead of sql. but when I am trying to copy and paste the nneeded content into teh field it just doesn't let me do it. what's wrong?

p.s. I wasn't sure what the best forum is to post this. Please let me know if there's a better place for this question.

--------------------------------------------------
Goals are dreams with deadlines
-------------------------------------

http://www.nimlok.com

 

[SQLSister]

read in books online about writetext and updatetext commands.

You should not be changing data through enterprise manager anyway. This is poor practice.


Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[DoubleV]

but why is it that I cannot even view the data in Enterprise Manager?
I know the data is there, because it displays when retrieved through the web page.

--------------------------------------------------
Goals are dreams with deadlines
-------------------------------------

http://www.nimlok.com

 

[monkeylizard]

EM only shows you text up to a certain size. I don't recall the cutoff, but at some point it begins to display <Long Text>

You should be able to VIEW the text that's in there using Query Analyzer, but that won't let you free edit the text.

Here's what I do:
Using Access, link the table to a new Access session. Open it using Access query. Once you position your cursor into the TEXT field type, press Shift+F2 and this will let you see the text a little better. You can free edit this up to a certain size. Once the text reaches a certain number of characters (and it's a lot, see thread183-1201829 for my problem with this, if any of you can help) then even Access won't help. Then using UPDATETEXT is the only option, but it's cumbersome.

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.

 

[vongrunt]

What happens if you resize row/column in EM grid?

------
[small]select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')[/small]

 

[monkeylizard]

Hey DoubleV,
If you hit the same problem I did in that you can't edit the text free-form in Access, take a look at thread183-1201829

That's my thread that explains how to use the UPDATETEXT command to change the text. It's a trial/error process, but it worked.

Monkeylizard
Sometimes just a few hours of trial and error debugging can save minutes of reading manuals.