I'm trying to create a script to clean up some columns between two revisions, and I'm having trouble with one that is full-text enabled:
ALTER TABLE tblNote DROP COLUMN colComments
I get the message:
Cannot alter or drop column 'colComments' because it is enabled for Full-Text Search.
I can't seem to find a way to remove the full-text index using scripting.
Any suggestions would be appreciated.