I want to query the PartXrefVend table using CONTAINS on the VendPartNum and am getting the following error: Severity: Error, Table: , Field: , RowID: , Text: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view ‘Erp.PartXRefVend’ because it is not full-text indexed.
Is there a work around? Can I cause this table to become fully indexed?