Error: Cannot alter or drop column 'x' because it is enabled for Full-Text Search
Found the solution myself:
-- You should call the DISABLE command
ALTER FULLTEXT INDEX ON TableName DISABLE
ALTER FULLTEXT INDEX ON TableName DROP (ColumnName)
ALTER TABLE TableName DROP COLUMN ColumnName
I know this is an old post,I got stuck up,where i had to alter a column in table rather than drop.below code worked for me...
EXEC sp_fulltext_column //Drop your column from full text search here
@tabname = '<table_name>' ,
@colname = '<column_name>' ,
@action = 'drop'
ALTER TABLE ... //Alter your column here
EXEC sp_fulltext_column //Add your column back to full text search
@tabname = '<table_name>' ,
@colname = '<column_name>' ,
@action = 'add'