Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Full-Text Search

Author  Topic 

nguyenvantruongthang
Starting Member

12 Posts

Posted - 2008-03-20 : 06:11:48
I can't create full-text index on a column which type is image.
I store *.doc files in that column using asp.net 2.0. But when i create full-text index on this column, SQL2000 didn't allow me to create and another column of that table is no problem.
Then I tried to use textcopy.exe to store word files in a that image column again but it can't.
Please help me!
Thanks in advance.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-20 : 23:15:07
It should work. Did you get any error?
Go to Top of Page

nguyenvantruongthang
Starting Member

12 Posts

Posted - 2008-03-21 : 03:38:34
I have created full-text table but when I queried and nothing found. Could you explain that if using full-text search to search .doc file must be using textcopy.exe to store file in database? (I was using asp.net to read .doc file to store sql2000)
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-03-21 : 17:06:12
Did you populate catalogy yet?
Go to Top of Page
   

- Advertisement -