1

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.

Kyle Noland
  • 1,039
  • 3
  • 19
  • 21

2 Answers2

4

You can just do the following:

SELECT * FROM sys.fulltext_catalogs

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

user12345
  • 103
  • 3
Damien Silveira
  • 41
  • 2
3

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');
GO

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.

GregD
  • 8,713
  • 1
  • 23
  • 35
  • 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