CODEWITHSUNDEEP
sqlsql-servert-sqlsql-server-2008full-text-search
DotnetSparrow
DotnetSparrow

Reputation: 27996

Full text search catalog name

I want to find the name of full text search catalog on my SQL Server 2008 database. How can I do that using SQl Server Management Studio or TSQL. I tried using:

SELECT FullTextServiceProperty('IsFullTextInstalled')

and it returns 1.

Upvotes: 4

Views: 2599

Answers (1)

Alex Aza
Alex Aza

Reputation: 78507

This query will help:

select name, *
from sys.fulltext_catalogs

You can have more than one full-text search catalog, so the query will return all of them. The one that is default will have is_default = 1.

Upvotes: 5

Related Questions