Sql-server – How to find the name of an existing full text catalog in SQL Server 2008 Express

full-text-catalogfull-text-searchsql serversql-server-express

I have SQL Server 2008 Express installed. Several months ago I created a full text catalog and index. I would like to index some additional table columns now, but I can't remember the name of the existing catalog. How do I find out the name of an existing full text catalog.

Hopefully this doesn't involve installing any new tools, because this is a production server.

Best Answer

You can just do the following:

SELECT * FROM sys.fulltext_catalogs

This will return the catalog names and should give you what you need.

Related Topic