After learning tips to create stoplist and adding/removing stopwords to fulltext index, let's learn about applying custom stoplist to fulltext index.

Below query will add stoplist SL3 to fulltext index on table.

 
-- Applying custom stoplist to Fulltext Index
ALTER FULLTEXT INDEX ON YourTableName  
SET STOPLIST SL3
GO

Below query will remove custom stoplist from fulltext index by applying system stoplist back.

 
-- Applying systm stoplist to Fulltext Index back
ALTER FULLTEXT INDEX ON YourTableName
SET STOPLIST SYSTEM
GO

You can read the previous tips to creating stoplist(http://beyondrelational.com/justlearned/posts/545/custom-stoplist-for-fulltext-index-in-sql-server.aspx) and adding/removing noise wrord to stoplist(http://beyondrelational.com/justlearned/posts/548/adding-and-removing-noisewordsstopwords-in-stoplist-of-fulltext-index-sql-server.aspx) for fulltext index.

Published under: SQL Server Tips ·  ·  ·  ·