Tuesday, June 26, 2012

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