Wednesday 25 December 2013

Drop full text index SQL

From time to time you may have to drop a full text index if so the following may be of intrest.

Get the catalog
SELECT name
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

Passwords Made Easy

Today i thought i would write about password security. As we are all aware passwords are important but we continue to use very poor password...