Full text search can not return result   

Hi all,
In my case, I build a full text search query. like "select * from _tt_fields where contains(string,'"development group"')",  when I click F5 then execute the sql, it returned the records, but when I click execute the query more than 4 times, it does not return anything!

From http://www.developmentnow.com/g/104_0_0_0_0_0/sql-server-fulltext.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

date: Wed, 16 Jan 2008 09:56:04 GMT   author:   ken

Re: Full text search can not return result   

Very rarely when you are in the middle of a merge you may get an
inaccurate count like  what you are seeing. it lasts for milli-
seconds.


On Jan 16, 4:56 am, ken wrote:
> Hi all,
> In my case, I build a full text search query. like "select * from _tt_fields where contains(string,'"development group"')",  when I click F5 then execute the sql, it returned the records, but when I click execute the query more than 4 times, it does not return anything!
>
> Fromhttp://www.developmentnow.com/g/104_0_0_0_0_0/sql-server-fulltext.htm
>
> Posted via DevelopmentNow.com Groupshttp://www.developmentnow.com

date: Wed, 16 Jan 2008 09:33:40 -0800 (PST)   author:   Hilary Cotter