Troubleshooting the full text index

If this error "Cannot use a CONTAINS or FREETEXT predicate on column" occours please re add the full text index by running the SQL commands below:

 

EXEC sp_fulltext_column Content, Content, 'add'
EXEC sp_fulltext_column Content, ContentNoHTML, 'add'

EXEC sp_fulltext_catalog 'Cat_Page', 'create'
exec sp_fulltext_table 'dbo.Page', 'create', 'Cat_Page', 'PK_Page';
exec sp_fulltext_column 'dbo.Page', 'title', 'add'
exec sp_fulltext_column 'dbo.Page', 'name', 'add'
exec sp_fulltext_column 'dbo.Page', 'MetaDescription', 'add'
exec sp_fulltext_column 'dbo.Page', 'MetaKeywords', 'add'

EXEC sp_fulltext_catalog 'Cat_Help', 'create'
exec sp_fulltext_table 'dbo.Help', 'create', 'Cat_Help', 'PK_Help';
exec sp_fulltext_column 'dbo.Help', 'title', 'add'
exec sp_fulltext_column 'dbo.Help', 'text', 'add'
exec sp_fulltext_column 'dbo.Help', 'textnohtml', 'add'