Hi all,
I wonder if it is possible to detect if a table has a FTS Catalog (not a FTS Index, that's not a problem) using the table's property list. I'm using FullTextCatalogName but this returns null when the FTS Catalog is empty (while the catalog still exists and hence could be dropped by a T-SQL query). An alternative would be executing a query I guess - what are my options
Addition: I could for example use sp_help_fulltext_catalogs but I'd like to know if there's a more direct way using a property.
Cheers and TIA for any help,
Pieter

How to detect if a table has a FTS Catalog - SQL Server 2005 FTS