• Thanks Alex S, it's all so obvious now, only 1 table! I looked at the properties of the FT index in the other CRM databases and grabbed a screen shot of the index.

    Just encase there are people out there who don't have multiple organisations to review and can't open the properties the table was: dbo.DocumentIndex and the indexed columns were: keyWords, SearchText and Title.

    Thanks again.