December 6, 2001 at 10:52 am
Our database has external files that need to be included in a user "topic/keyword" search. The files maybe different formats such as Word, html, Excel, pdf. Does SQL Server 2000 have tools/topics for creating an index/catelog table to have these files as part of the search?
Thanks in advance...
December 6, 2001 at 7:15 pm
Take a look at Index Server. It's not SQL, but it is an OLEDB data source that you can query against using sort of SQL syntax. I think Jon Winer has an article posted - take a look at his page under columnists on the main menu. I'd go for loading them as blobs if you can, then full text search can handle them. I know EVERYONE else recommends against it, but that was last years hardware - it can work pretty good.
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply