Full text queries

 

SELECT

    FULLTEXTCATALOGPROPERTY(cat.name,'ItemCount') AS [ItemCount],

    FULLTEXTCATALOGPROPERTY(cat.name,'MergeStatus') AS [MergeStatus],

    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateCompletionAge') AS [PopulateCompletionAge],

    FULLTEXTCATALOGPROPERTY(cat.name,'PopulateStatus') AS [PopulateStatus],

    FULLTEXTCATALOGPROPERTY(cat.name,'ImportStatus') AS [ImportStatus]

FROM sys.fulltext_catalogs AS cat

 

DROP FULLTEXT CATALOG yourcatalog

 

SELECT t.name AS TableName

FROM sys.fulltext_indexes fti

JOIN sys.tables t ON fti.object_id = t.object_id

JOIN sys.fulltext_catalogs ftc ON fti.fulltext_catalog_id = ftc.fulltext_catalog_id

WHERE ftc.name = 'yourcatalog';

 

DROP FULLTEXT INDEX ON yourtable;