Large text block into ntext -- sql server full text search

EdwardH
5/11/2005 2:46:03 AM

How can I get a block of text into an ntext field. Have tried copy and paste
out of Notepad into field in Enterprise Manager? But it truncates.
Is there a command line that will put text into specific field in specific
table?

Hilary Cotter
5/11/2005 11:21:45 AM

Use the ado stream object or textcopy

have a look at this link for more info on how to do this.

http://www.indexserverfaq.com/SQLLoadADO.htm

http://www.indexserverfaq.com/TextCopy.htm

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

[quoted text, click to view]

sql server full text search : Large text block into ntext