Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Full Text Index - Stoplist

Author  Topic  DSE_SQL Starting Member 1 Post Posted - 2012-02-17 : 08:58:21 I activated a FULL TEXT CATALOG in my database. The Query 'select * from sp_ad where contains(street, '"PLATZ*" AND "AM*"')' gives me, among others, '31 AM PLATZ BERLIN' but ignores the entry '12 AM PLATZ BONN'. The stoplists is set to 'off' and the full text index for the table was repopulated several times. Why doesn't find SQL Server my entry properly? Can anyone help?