[SQL Server] Afficher les informations des index FullText

  • Imprimer

SELECT DB_NAME()AS Base, T1.name,T2.is_enabled,T2.crawl_start_date,T2.crawl_end_date

FROM [sys].[fulltext_catalogs] T1

JOIN [sys].[fulltext_indexes] T2 ON T2.fulltext_catalog_id=T1.fulltext_catalog_id

WHERE T1.name='mon_catalogFullText'