full tect search

Results 1 to 2 of 2

Thread: full tect search

  1. #1
    Join Date
    Dec 1969

    Default full tect search

    i am uploading word doucments onto my sqlserver database as binary.Is there a way i can add a serach capability.For ex if one enters a word say vaction it should get all the word doucments having the word vacation

  2. #2
    Join Date
    Dec 1969

    Default RE: full tect search

    I don&#039;t think it is possible to search binary fields like that.<BR>The way I have solved a similar problem in the past is by uploading the word documents to a directory on the filesystem, and creating an index with MS Indexing Services on that directory. <BR>In SQL Server you can setup this index as a &#039;Linked Server&#039;, and then you can access the index through SQL queries.<BR><BR>Or if you only need to search those documents and nothing from the database, it is of course easier to directly search the index.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts