Querying Linked Servers

To issue full-text queries against linked servers, you must first create a full-text index on the target tables and columns on the remote server. Next you must add the remote server as a linked server. That being done, you can use a four-part name in CONTAINS or FREETEXT full-text queries to query the target tables and columns on the linked server.

See Also

Concepts

Full-Text Search Queries

Other Resources

sp_addlinkedserver (Transact-SQL)
CONTAINS (Transact-SQL)
FREETEXT (Transact-SQL)
Schema Functions Supporting Distributed Queries

Help and Information

Getting SQL Server 2005 Assistance