On some SQL Server 2005 installations the full-text search is very slow (> 30 seconds). To fix this issue we found the following solution on the net:

„

Yes the resolution was to upgrade to SQL 2008

…

We decided to go with the option of sticking with SQL 2005 and removing the security check; Meaning the full-text indexing agent is loaded without regard to whether it has been properly signed or not.

Here's the SQL command:

Code Snippet

sp_fulltext_service 'verify_signature', 0;
GO

“

Q: http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/699221f0-a850-4f1d-b1db-a067a172f866/