Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In MS SQL Server 2008 R2 there is replication of table with fulltext index on it. But stoplist that is associated with replicated fulltext index doesn't replicate.

Is there any possibility to replicate stoplist also?

share|improve this question

migrated from Apr 26 '13 at 17:23

This question came from our site for professional and enthusiast programmers.

Apologies for the short response but... No. – Mark Storey-Smith Apr 27 '13 at 1:38

stoplist can't be replicated but there is one ugly way to do it. Words in Stop lists are stored in sys.fulltext_stopwords . Using linked server you can query this table and compare it on secondary server . If there are any changes then run alter command on secondary to add\remove those changes from stoplist.


Can be setup as recurring job. Not a decent method but should work fine.

share|improve this answer
Note that a change in the Stoplist does not reindex existing content. If that is required you would also need to start a full population. E.g. ALTER FULLTEXT INDEX ON mytable START FULL POPULATION; – RLF Aug 2 '13 at 13:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.