[SQL Server] Afficher les informations des index FullText
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'