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
 SQL Server Administration (2000)
 Full text indexing with index server

Author  Topic 

1fred
Posting Yak Master

158 Posts

Posted - 2003-02-07 : 15:12:03
Robvolk, in reponse to an article about storing word document into sql server, you proposed this solution: "
The one single ADVANTAGE I've seen in storing documents in a SQL Server table is the ability to full-text index them (under SQL Server 2000), however files can still be FT-indexed using Index Server, and Index Server can be linked into SQL Server and queried. To me, it's not enough of an advantage to warrant storing documents in a table. "

Is this an easy job to implement? Can you give me URL or example on how to do this.

Thanks



robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-02-07 : 16:02:40
These should help:

http://msdn.microsoft.com/library/en-us/acdata/ac_8_qd_12_0h0l.asp
http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefindservprovspec.asp
http://msdn.microsoft.com/library/en-us/ado270/htm/mdrefadoprovinfo.asp

The first link matches one of the entries in Books Online for "indexing service". I haven't personally tested this kind of configuration but I've heard from others who have that it works pretty well and it's pretty easy to set up.

Go to Top of Page
   

- Advertisement -