Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

You can just do the following:

select * From sys.fulltext_catalogs

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

share|improve this answer

From here:

To find the filegroup of full-text index on a table or view, use the following query, where object_name is the name of the table or view:

SELECT name FROM sys.filegroups f, sys.fulltext_indexes i 
   WHERE f.data_space_id = i.data_space_id 
      and i.object_id = object_id('object_name');

I also believe that the name of files located here:

C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\FTData

should give you some idea of the name of your catalogs.

share|improve this answer
This query executes fine but does not return any data in the name column. I know there is a fulltext catalog set up. Also, there was nothing on disc that shed any light as to the name. – Kyle Noland Apr 18 '10 at 19:23

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.