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