Hello, can you help me as I am too stupid to figure this out for myself.
I want to enable FullText search on a Text column. I have added a FullText catalog, and added the column to the catalog and populated the index.
The FullText search service is running.
However I get no hits. I should point out that StopWords is off.
If my column contains 'Attrn' and I search on CONTAINS (MyColumn,'Att') I would expect to get a hit, but I don't.
Are there any other bear traps I haven't considered?