FullText Catalog

If you want to enable a fulltext catalog then here is the statement:

use <dbname>

go

sp_fulltext_database 'enable' 

to stop/start population, rebuild or drop use this statement

use <dbname>

go

sp_fulltext_catalog '<catalog name>','create/drop/rebuild/stop', '<path if you are creating new>'

to get  all fulltext catalog information for that database


use <dbname>

go 

EXEC sp_help_fulltext_catalogs '<catalog name>'

to get fulltextcatalog property

use dbname

go 

select FULLTEXTCATALOGPROPERTY('catalog name','status')