• 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.

    Alex S