views:

439

answers:

1

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.
+2  A: 

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
Eduardo Molteni