The Question and Answer Board

[jhalada]

Bob,

That's basically the planned approach (unless Yukon has something better, which I'm praying for)

Here is what MSFT says under top 10 features of Yukon:

Full-Text Search Enhancements:

SQL Server "Yukon" will support rich, full-text search applications. Cataloging capabilities will be enhanced to provide greater flexibility when determining what is cataloged. Query performance and scalability will be improved dramatically, and new management tools will provide greater insight into the full-text implementation.
http://www.microsoft.com/sql/yukon/productinfo/top30features.asp

You should be able to get a Beta, or even Alpha, given that you are such a high profile site. It would definitely be worthwhile to check it out before you put any work into rolling your own.

Joe