Important queries related to Fulltext Indexing Server configuration

0

Category:

These are few important queries which are helpful while you are installing Fulltext Indexing Server .

SELECT r_object_id,index_name,ft_engine_id,is_standby
from dm_fulltext_index

The query returns two rows, one with an index name ending in 00, which represents the
primary index, and one with an index name ending in 01, which represents the standby index

SELECT r_object_id,object_name FROM dm_ftengine_config