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
There Goes AIIM CIP
2 years ago
Comments (0)
Post a Comment