Post reply

File Search in SQL Server 2K

  • December 6, 2001 at 10:52 am

    #77819

    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

    #420857

    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

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply