Is it possible to get the list of Full Text Search noise/stop words from SQL Server 2005 by querying the database? I am aware that the noise words are in a text file ~/FTData/noiseEng.txt but this file is not accessible to our application. I've look at the sys.fulltext_* tables but these don't seem to have the words. ...
if I am running sql server 2008 in compatibility level 90 (sql 2005) does it use the stoplist in the resource database or does it use ftdata\ENU.txt files??? also if I make my own stoplist in 2008 (using compatibility 100) can I ignore the system stoplist and use my own with my full text queries or will it use the system and my custom s...
Hi, I am trying to search against a Database with MS Word Documents as BLOBS, full-text indexed (neutral language) an exact word or phrase contains dashes (for example : "-c-erb-B2"). The problem is that FTS works in a different way and break it, at "erb" and "B2" and results include additional records that documents include erb or B2....