Skip to content

Instantly share code, notes, and snippets.

@xpando
Created June 9, 2012 15:30
Show Gist options
  • Save xpando/2901449 to your computer and use it in GitHub Desktop.
Save xpando/2901449 to your computer and use it in GitHub Desktop.
Full Text Catalog properties
SELECT
cat.name,
ItemCount = FULLTEXTCATALOGPROPERTY(cat.name, 'ItemCount'),
MergeStatus = FULLTEXTCATALOGPROPERTY(cat.name, 'MergeStatus'),
PopulateCompletionAge = FULLTEXTCATALOGPROPERTY(cat.name, 'PopulateCompletionAge'),
PopulateStatus = FULLTEXTCATALOGPROPERTY(cat.name, 'PopulateStatus'),
ImportStatus = FULLTEXTCATALOGPROPERTY(cat.name, 'ImportStatus')
FROM
sys.fulltext_catalogs AS cat
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment