when I am querying the local database instead of live database I get the following error:
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Shop' because it is not full-text indexed.
Why is this happening?
views:
98answers:
1
+1
A:
It means pretty much what it says; Full-text indexing isn't turns on for your Shop table. Full-text indexing allows all the text within a field to be searched while querying, which is what I assume you want to do.
You probably have full-text indexing turned off on your development system, but on on your live server.
Please read this page which explains how to enable it.
Soviut
2009-03-06 05:32:21