Hi Peddie,

Thanks for your reply. I have dropped the existing full text index and catalog, and recreated it. This time I changed the data type of the column on which I need full-text indexing feature to varchar instead of text. And it worked fine by populating the index properly. However when i make a change to any data of this column, then the index is not re populated with new values. Of course I used "WITH CHANGE_TRACKING AUTO" while creating the full-text index. But once I manually repopulate the index by using the command "ALTER FULLTEXT INDEX ON tablename START UPDATE POPULATION;" . The index is updated.

When I check the error log of sql after using the update command it says:

Error '0x80004005' occurred during full-text index population for table or indexed view '[databasename].[dbo].[tablename]' (table or indexed view ID '1268199568', database ID '5'), full-text key value 0x00000053. Attempt will be made to reindex it.

The component 'sqlfth90.dll' reported error while indexing. Component path 'C:\Program Files\Microsoft SQL Server\90\COM\sqlfth90.dll'.

This is a very frustrating issue. I hope I will be able to come up with the solution by help from you guys.

Thanks

Best Regards

solidroots