MSSQL 2008 FTS CONTAINSTABLE Not Returning More Than Five Rows
Posted
by Elijah Glover
on Stack Overflow
See other posts from Stack Overflow
or by Elijah Glover
Published on 2010-05-25T03:44:04Z
Indexed on
2010/05/25
3:51 UTC
Read the original article
Hit count: 345
I have a single table called "Indexes", it contains one nvarchar and three ntext columns (all Full Text Indexes). Index is up to date.
CONTAINSTABLE(Indexes, *), 'test', 5) //5 results
No matter what I change the above keyword too, it only returns the first 3-5 results. It should roughly return 90-120 results, for the above query.
SELECT count(*) FROM Indexes WHERE [Description] like '%test%' //122 results
How would I start to troubleshoot this problem?
© Stack Overflow or respective owner
