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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy