You can just do the following: SELECT * FROM sys.fulltext_catalogs This will return the catalog names and should give you what you need.


I know this is an old thread, but I had the same issue, and just disable full-text search, restart SS, re-enable full text search, re-start SS fixed it for me.

Only top voted, non community-wiki answers of a minimum length are eligible