Editing <long text>

25 Aug 2006 2:38 AM

Audrey Ng

Hi,

In SQL Server 2000, I have a field that's text but when I open the table
in Enterprise Manager, that field just says <Long Text> and I need to
make modification to that field. I don't think I can use REPLACE and
when I open it in Query Analyzer, only part of the string appears. Is
there a way for me to edit the field?

Audrey

*** Sent via Developersdex http://www.developersdex.com ***

25 Aug 2006 2:54 AM

Steve Kass

Audrey,

Enterprise manager can only display about 900 characters of
a text column. From Books Online topic "Editing Rows in
the Results Pane,"

"You can edit a memo-type column (such as a text, memo, or long
character column) if the column does not display <Long Text>. The
Results pane can accept up to 900 characters of text in memo-type
columns. If you are typing in a cell and exceed the amount of text
that the Results pane can accept, the Query Designer will beep to
indicate that you have exceeded this limit."

See the Books Online article "Managing ntext, text, and image Data"
for some ways to modify text data.

Steve Kass
Drew University
www.stevekass.com

Audrey Ng wrote:

Show quote

>Hi,
>
>In SQL Server 2000, I have a field that's text but when I open the table
>in Enterprise Manager, that field just says <Long Text> and I need to
>make modification to that field. I don't think I can use REPLACE and
>when I open it in Query Analyzer, only part of the string appears. Is
>there a way for me to edit the field?
>
>Audrey
>
>
>
>*** Sent via Developersdex http://www.developersdex.com ***
>
>