>Thanks, removing the indexes and then the catalogs is the way to do it.
>
>Basically, the following is the approach used:
>
>

>IF EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[MyTable]'))
>ALTER FULLTEXT INDEX ON [MyTable] DISABLE
>GO
>
>IF EXISTS (SELECT * FROM sys.fulltext_indexes fti WHERE fti.object_id = OBJECT_ID(N'[MyTable]'))
>DROP FULLTEXT INDEX ON [MyTable]
>GO
>
>IF EXISTS (SELECT * FROM sysfulltextcatalogs ftc WHERE ftc.name = N'MyTable')
>DROP FULLTEXT CATALOG [MyTable]
>

Shouldn't be the last one sys.fulltext_catalogs, for consistency ?