开发者

Full text timed out Exception

I'm using freetex开发者_如何学运维t in my query but I encounter this error just the first time i run the query. what's wrong? I didn't have this problem in SQL server 2005. I just have 10 records in my table.

Word breaking timed out for the full-text query string. This can happen if the wordbreaker took a long time to process the full-text query string, or if a large number of queries are running on the server. Try running the query again under a lighter load.

I'm using SQL server 2008 version 10.0.1600.22 ((SQL_PreRelease).080709-1414 ).

I have read about wordbreaking dll in the other forums but I don't kow what to do. this is a simplified code of my query:

select tbl_Workshops.Name as WorkshopName
from tbl_Workshops
 where (@Creteria='""' or freetext(tbl_Workshops.Name,@Creteria))


The word breaker may be trying to verify signature, and unable to reach the service.

Try...

SELECT FULLTEXTSERVICEPROPERTY('VerifySignature');
GO
-- if 1, then turn off verify_signature
EXEC sp_fulltext_service 'verify_signature', 0;
GO


Make sure that the service called SQL Full-text Filter Daemon Launcher (INSTANCE) is running and logs on using the same credentials as SQL Server (INSTANCE)

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜