I am currently researching Full-Text Search (FTS) in SQL 2000. One thing I have thought about is how to architect search functionality for data residing in distributed partitioned views (DPV). We're thinking of splitting our data into two or more nodes, and using DPVs to select the data. But as far as I know, it is not possible to use FTS to full-text index views. That means I would have to full-text index each underlying table of the DPV and send each search to everyone of them. But that's no good of course. Or am I just wrong in some way? Is there some other nice way of doing it with FTS. We probably won't use FTS anyway, but I would like to give it a test.

/Chris