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)
精彩评论