giles.clapham (1/27/2011)
I don't want to drop the full text index as it's got loads of tables indexed and if I recreated it I'm scared i will miss one out or one of the columns within.
Don't worry Microsoft CRM has only one table in Full-Text called DocumentIndex.
You can easily recreate the FT catalog for it. Here is what you do.
1.In your CRM DB (click +) go to Storage--->Full Text Catalogs---> (right click on) "ftcat_documentindex_bunchofnumbers" choose properties and then click on Tables/Views.
2.Take a screen shot ( click PrintScreen/Sysrq Button top right corner of keyboard)
3.Now open Microsoft Paint and paste it then save it. You'll come back to it later.
4. Now Again (right click on) "ftcat_documentindex_bunchofnumbers" choose
Script Catalog as--->Create to--->New Query Editor window.
You will see SSMS will paste the code for creation of the catalog in a new window.
5.Now (right click on) "ftcat_documentindex_bunchofnumbers" choose DELETE. Click OK.
6.Now run that script which SSMS pasted.
7.Then go back open that image which you took a screen shot of and again (right click on) "ftcat_documentindex_bunchofnumbers" choose properties and then click on Tables/Views.
Here you choose the same table DocumentIndex and fields and that's it.
8.Then go to Tables--->right click on DocumentIndex-->FULL Text Index-->click on start full population.
Your FT index is ready.