When executing a query using the keyword CONTAINS on a Linked Server that has a Full-Text column in the table I am using, I get the following Error:
Cannot use a CONTAINS or FREETEXT predicate on table 'LINKED_SERVER.DATABASE.DBO.TABLE' because it is not full-text indexed.
But if I run the query on the server that is Full-Text indexed it works.
Can you run a full-texted query on a Linked server or not?
Or am I doing something else wrong?
Thanks
Cannot use a CONTAINS or FREETEXT predicate on table 'LINKED_SERVER.DATABASE.DBO.TABLE' because it is not full-text indexed.
But if I run the query on the server that is Full-Text indexed it works.
Can you run a full-texted query on a Linked server or not?
Or am I doing something else wrong?
Thanks