Create a FTS in sql2005 on multile fields in multiple tables

full-text-search

How can I create a Full Text Search catalog on 3 fields where one is in a second table?

Best Answer

You'd have to create a view and create an FT index on this view

From MSDN "Getting Started with Full-Text Search" (my bold)

Create a full-text index on the table or indexed view

I haven't tried this myself so don't have any tips. However, an indexed view is the only way to have any index span tables.