none
Removing Stopwords in 2008 R2

    Question

  • Hi,

    I've just moved over to 2008 R2 and I'm getting blocked on 2 words "more" and "than" (genius as it's a UK company name), I assume it's because they're stopwords, so I want to remove them from the list but I can't find the list, anyone have any idea where it is, I've seen people say "remove it from the list but no one seems to know where it is in 2k8.

    Thanks in advance,

    Lloyd.


    My wife says I never listen to her, or something like that anyway.
    Friday, February 4, 2011 4:04 PM

Answers

  •  drill down you your database, and then storage folder, Full-text stop lists, Rigth click on Full-Text stop lists and select new full -text stop list.

    Give it a name and either create an empty stop list or Create from the system stop list.

    If you use the system stop list you will need to issue the following commands in your database.

    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Neutral';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Traditional Chinese';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'English';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Japanese';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Thai';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Simplified Chinese';

    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'British English';

    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Neutral';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Traditional Chinese';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'English';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Japanese';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Thai';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Simplified Chinese';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'British English';


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked as answer by StraNGeLaD Wednesday, February 9, 2011 11:33 AM
    Saturday, February 5, 2011 1:31 AM

All replies

  •  drill down you your database, and then storage folder, Full-text stop lists, Rigth click on Full-Text stop lists and select new full -text stop list.

    Give it a name and either create an empty stop list or Create from the system stop list.

    If you use the system stop list you will need to issue the following commands in your database.

    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Neutral';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Traditional Chinese';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'English';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Japanese';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Thai';
    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'Simplified Chinese';

    ALTER FULLTEXT STOPLIST [test]  DROP  'more' LANGUAGE 'British English';

    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Neutral';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Traditional Chinese';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'English';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Japanese';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Thai';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'Simplified Chinese';
    ALTER FULLTEXT STOPLIST [test] DROP  'than' LANGUAGE 'British English';


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked as answer by StraNGeLaD Wednesday, February 9, 2011 11:33 AM
    Saturday, February 5, 2011 1:31 AM
  • then you have to make sure your full-text index uses this stop list and rebuild your catalog.

    Right click on your table, select full-text index then properties, and in the general tab click on the full-text stop list drop down and pick your stop list.


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    Saturday, February 5, 2011 1:34 AM
  • Thanks for all that, in the end I settled for setting the stoplist to off:

    ALTER FULLTEXT INDEX ON [tablename] SET STOPLIST = OFF


    My wife says I never listen to her, or something like that anyway.
    Wednesday, February 9, 2011 11:35 AM