Full text query on VarBinary column is not returning rows

• vlsivajyothi

  SSC Journeyman

  Points: 91

  More actions

  May 28, 2009 at 10:51 am

  #93569

  Hello All,

  SQL Server2005 is installed in Windows 2003 Server(64-Bit) and updated with Sql Server SP2 and SP3. I installed FilterPack and registered with SQL server as per the steps given in the following link

  http://support.microsoft.com/kb/945934

  I'm trying to do Fulltext search on varBinary column (contains visio documents).

  When setting up the full-text index, I specified the type column(.vsd), in addition to picking the binary column.

  then I run the following full-text query.

  select * from visDocuments where freetext([Document],'Dell')

  But its not returning the rows. I'm sure one of the row is having the word Dell.

  Please guide me to solve this problem. Thanks in advance.

• mattedue

  Mr or Mrs. 500

  Points: 593

  More actions

  May 30, 2009 at 10:11 am

  #1002403

  EDIT: sorry, I didn't read the first two lines properly and the forum won't let me delete the post -_-

  anyway, trivial question, have you tried doing as follows?

  - sp_fulltext_service 'load_os_resources', 1

  - rebooting

  - rebuilding the indexes from scratch