How do I find a list of tables that have a FULLTEXT INDEX applied to them on a given database?
For example, you can enable and disable a FULLTEXT INDEX like this:
ALTER FULLTEXT INDEX ON [dbo].[OBJECT_FACT] ENABLE
ALTER FULLTEXT INDEX ON [dbo].[OBJECT_FACT] DISABLE
Best Answer
To find a list of tables that have a
FULLTEXT INDEX
:To enable and disable a
FULLTEXT INDEX
refer msdnThe preferred method is to use
ALTER FULLTEXT INDEX [myFTindex] {ENABLE/DISABLE}
instead of the deprecatedsp_fulltext_table
.