I'm refactoring an old database and removing columns no longer in use. The DB used to have full text indexing, so, some column are marked for full text.
How can I remove them?
Notes:
- DB is MS SQL Server Express 2008
- Full text search service is no longer installed
Edit:
I have tried
ALTER FULLTEXT INDEX ON tableName DROP (ColumnName)
But gets this error:
Full-text crawl manager has not been initialized. Any crawl started before
the crawl manager was fully initialized will need to be restarted. Please
restart SQL Server and retry the command. You should also check the error
log to fix any failures that might have caused the crawl manager to fail.