How to get the full-text catalog name of mssql 2005 database through query?

Hello All,

Could any one please let me know how can I get the name of full-text catalog of a MS-SQL database through query?

My Intention to write an SQL-query is to do the following:

1. check if a databse has full-text catalog enabled.

2. If so then get the name of the full-text catalog.

3. Add "MOVE sysft_<full-text catalog name> TO <desired loc>.

Thanks and Regards,

Anbu

Here's a script that will get you the databases, and you can join that to the fulltext catalog views from there to do the rest of your work:

select * from sys.databases
where is_fulltext_enabled = 1
order by name

Paste this link in the URL bar of Books Online to find the catalogs for fulltext:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/ab95e6f8-51dc-4018-9d19-cc0a6de893a5.htm

Buck Woody

|||

If a database has fulltext catalog enabled, then

select name,path from database-name.sys.fulltext_catalogs

should return the name of the fulltext catalog and the physical location of the catalog.

If the database is not enabled with any fulltext catalog then the above query will not return any rows.