Full Text Index

Question

I have added a new column into my table to which i want to make as full text index Earlier I have a column which is full Text Indexed already. How can I make two columns as Full Text Indexed. Thanks

Pankaj Kumar Choudhary · Answer

Ya! Thanks i really forget that we can alter the Full Text Index so Thanks for your consideration .......

Nayeem Mohammed · Answer

Thanks for Replay I dont need to delete existing Index. I can update the existing Index with this Query ALTER FULLTEXT INDEX ON ADD ([ColumnName]); It works for me I can add a new column as Full Text Index in existing one Thanks.

Pankaj Kumar Choudhary · Answer

Hello! Nayeem SQL Server allow only one full-text index is allowed per table or indexed view and this index can contain up to 1024 columns. If you have already a full text index then drop the FULL TEXT Catalog and create new full text catalog that contain full text index for 2 columns......