Cannot alter or drop column ‘Column Name’ because it is enabled for Full-Text Search

If you r seeing this message while trying to modify a column in one of your SQL tables it means you r trying to edit a column which is being indexed for Full-Text Search.

What you need to do is simple;

1-) Remove the indexing on the column

EXEC sp_fulltext_column
@tabname = 'table_name' ,
@colname = 'column_name' ,
@action = 'drop'

2-) Modify the colummn

3-) Add the indexing back

EXEC sp_fulltext_column
@tabname = 'table_name' ,
@colname = 'column_name' ,
@action = 'add'

Good Luck,
Serdar.

Leave a Reply

Your email address will not be published. Required fields are marked *