Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
FullText min Length should be 1

Proposed Answer FullText min Length should be 1

  • Wednesday, December 24, 2008 12:30 PM
     
     
    Sign In to Vote
    0
    is it possible to set the fulltext min length to 1..
    Cause when i type something ike this... "Mercedes E" then it retuns nothing.

    How can I make this avabile so it can searcjh for 1 character also.
    NA
    • Moved by Aaron Alton Thursday, December 25, 2008 2:43 AM This is a Full Text question (Moved from SQL Server Database Engine to SQL Server Search)
    •  
     

All Replies

  • Tuesday, January 06, 2009 3:20 PM
     
     Proposed Answer
    Sign In to Vote
    0
    remove e from your stop word list (SQL 2008)or noise word file (SQL 2005), rebuild your catalog, restart your search service and try agian.
    looking for a book on SQL Server replication? http://www.nwsu.com/0974973602.html 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