How can I create a Full Text Search catalog on 3 fields where one is in a second table?
Create a FTS in sql2005 on multile fields in multiple tables
full-text-search
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)
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.