Get the catalog
SELECT name
FROM sys.fulltext_catalogs;
FROM sys.fulltext_catalogs;
Get the table
sp_help_fulltext_tables;
drop the table catalogs
DROP FULLTEXT INDEX ON tablename
This may need a bit of work as i have just copied it from some notes i made but i should point you in the right direction.
No comments:
Post a Comment