Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 stackoverflow.com Apr 26 '13 at 17:23

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

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

1 Answer

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.

ALTER FULLTEXT STOPLIST YourStopLIstName ADD 'en' LANGUAGE 'Spanish';

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
add comment

Your Answer

 
discard

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.