Troubleshooting SQL Server Full-Text Search Problems

9. Error about ignored words

If you encounter errors indicating that the full-text query contains only ignored words, try to rewrite this query to a phrase-based query, removing the noise words.

You will get an error indicating that the full-text query contains ignored words when the CONTAINS predicate is used with words such ‘OR’, ‘AND’ and ‘BETWEEN’ as searchable phrase.

For example, this select statement returns error:

SELECT ProductName FROM Products
WHERE CONTAINS(ProductName, ‘and OR between’)

 

10. Rewrite English Query’s questions, so that these questions will not require a full-text search on a table with a uniqueidentifier key.

Asking English Query’s questions that require a full-text search on a table with a uniqueidentifier key may cause English Query to stop responding.

 

11. BackOffice 4.5 issues

If you decide to install the full-text search by using the BackOffice 4.5 custom setup, after a successful installation of SQL Server 7.0 (without installing full-text search), you should run Setupsql.exe from the BackOffice CD-ROM(2) (SQL70Machine_platformSetupSetupsql.exe)

You are not allowed to do it by using the BackOffice 4.5 setup, because the BackOffice Custom Installation dialog box falsely indicate that the full-text search has been installed already.

 

12. Time Out Errors

If you encounter an error indicating that the full-text query has timed out, try to reduce the size of the result set, or increase the ‘remote query timeout’ setting, or insert the full-text query result set into a temporary table instead of streaming the results directly to the client.

 

13. Make a single column unique index for the table you want will be used in a full-text query.

Full-text indexing cannot work on a table that has a unique index on multiple columns. If the table you want will be used in a full-text query does not currently have a single column unique index, add an IDENTITY column with a UNIQUE index or constraint.

 

14. Upgrade to SQL Server 2000, if you need to work with full-text search in a clustered environment.

Full-text search is not available in a SQL Server 7.0 clustered environment.

 

Pages: 1 2




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |