Full Text Search

Question

I want to find the name of the full-text search directory in my SQL Server 2008 database. How to do this using SQl Server Management Studio or TSQL. I tried using:

SELECT FullTextServiceProperty('IsFullTextInstalled') 

and it returns 1.

Answer 1

This query will help:

 select name, * from sys.fulltext_catalogs 

You may have more than one full-text search directory, so the query will return all of them. The one that defaults to is_default = 1 .