Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.BDF_Form' because it is not full-text indexed.

• lefrancisco1

  Say Hey Kid

  Points: 704

  More actions

  September 24, 2014 at 6:45 am

  #299619

  Hi Folks,

  I have a problem while retrieving a search query , please come up with suitable idea to make it happen, please find below the exception which iam executing the query.

  Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.BDF_Form' because it is not full-text indexed.

  Thanks,

  Leo

• HanShi

  SSC-Dedicated

  Points: 33506

  More actions

  September 24, 2014 at 6:58 am

  #1747820

  Did you execute all steps to enable and setup FULL TEXT on the database/table?

  http://msdn.microsoft.com/en-us/library/ms142497.aspx

  ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **