Managing XML field with Enterprise Manager

14 Jul 2005 3:48 PM

Patrick

With SQL Server 2000, I have a table with a field called fldhistory, defined
as a ntext [16] field.

This column is intended for storing some archived history data in XML format.

I have an example XML which is valid and:
1) has <1300 characters, including spaces
2) Wel-formed, readable by IE
3) <10 lines

However, I can't put anything more than say a few hundred charaters in this
column under Enterprise Manager (for testing purposes), the past option is
simply disabled and if I try ctrl-V, I get a Windows warning tone.

why is this and how can I fix this? the ntext column should be capable of
handling >1300 characters!

15 Jul 2005 7:42 AM

Sophie Guo [MSFT]

Hello,

Please refer to the following information in SQL server Books Online(BOL):

Topic: Adding ntext, text, or image Data to Inserted Rows
------------------------------------------------------------------------
These are ways to add ntext, text, or image values to a row:

"    Specify relatively short amounts of data in an INSERT statement in the
same way char, nchar, or binary data is.
"    Use the WRITETEXT statement. For more information, see WRITETEXT.
"    ADO applications can use the AppendChunk method to specify long amounts
of ntext, text, or image data. For more information, see Managing Long Data
Types.
"    OLE DB applications can use the ISequentialStream interface to write new
ntext, text, or image values. For more information, see BLOBs and OLE
Objects.
"    ODBC applications can use the data-at-execution form of SQLPutData to
write new ntext, text, or image values. For more information, see Managing
text and image Columns.
"    DB-Library applications can use the dbwritetext function. For more
information, see Text and Image Functions.
------------------------------------------------------------------------

You can use above ways to insert ntext data. Please also refer to the
following topics in BOL:

"Using text and image Data"
"Managing ntext, text, and image Data"
"text, ntext, and image Data When text in row Is Set to ON"

You can also refer to the following articles which provide good information:

194975 How To Read and Write BLOBs Using GetChunk and AppendChunk
http://support.microsoft.com/?id=194975

258038 How To Access and Modify SQL Server BLOB Data by Using the ADO Stream
http://support.microsoft.com/?id=258038

I hope the information is helpful.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.