Tell me more ×
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.
up vote 2 down vote favorite

I'm trying to replicate what SQL Server 2008 is doing when generating full-text indexes, but I'm having a hard time finding a list of which characters SQL Server 2008 considers to be word breakers.

Is there a list out there specifying which characters SQL Server 2008 will break words on for full-text indexes for English?

share|improve this question

1 Answer

up vote 5 down vote

The per language noise list (also referred to as stop list) and thesaurus files are in the MSSQL/FTData/ folder. The noise files are plain text, the thesaurus XML, so both can be inspected or changed easily.

Configuring Full-Text Linguistic Components in BOL has the details.

share|improve this answer
I'm looking for the criteria where SQL server breaks up the words.. i.e. "Hello World" gets broken into two due to the space – John Dec 9 '11 at 19:05
@John - its in the link he posted....maybe read it first. – JNK♦ Dec 9 '11 at 19:30
@JNK: where does it list out the word breakers? – John Dec 9 '11 at 19:36
took me 2 clicks to get there from his link – JNK♦ Dec 9 '11 at 19:38
show 1 more 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.