Cannot use a CONTAINS or FREETEXT predicate on table or indexed view

Question

Hello

I'm getting the below error when I perform a FREETEXT search on my table that is full-text indexed, populated.

Msg 7601, Level 16, State 2, Line 3
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Production.ProductDescription' because it is not full-text indexed.

Thank you

Answer 1

what does your query look like?

---

looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

Answer 2

I solved these kind of Problems:

On subscriber DB before setting subscription:first run sp_fulltext_database enable

Changed Publication Artcile property: replicate full text indexes

chnage native mode: publication property.

and installing full text components or feature on subscribers.

---

Manish

Answer 3

Manish - there is no indication that replication is involved in the original query.

---

looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941