Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error - Contains applied to remote table (linked server) Expand / Collapse
Author
Message
Posted Monday, September 24, 2012 8:20 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 16, 2014 12:02 PM
Points: 183, Visits: 40
Hi good day!

The error is the next:

Variable parameters can not be passed to fulltext predicates: contains, freetext and functions: containstable, freetextable applied to remote table

This happens when I try to do a query with contains in column in remote table for linked server. The table - column remote, I applied the catalog text, index and fill. Why I can't do the query?

Happy day and Thanks in advance for your support
Post #1363517
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse