Showing posts with label index. Show all posts
Showing posts with label index. Show all posts

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.

Multi Point USB Charger

  USB Plug Charger, 4-Port USB Fast Charger Plug with 33W Intelligent Quick Charge 3.0 Wall Charger, Multi USBPower Adapter UK Fast Charging...