Ignored words in full-text searches

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Ignored words in full-text searches

Author

Topic

ed_ward_graham
Starting Member

15 Posts

Posted - 2008-12-23 : 09:29:17

Hi,

I am using Microsoft Indexing Service to index a set of PDF files and then running the following SQL code (within a stored procedure):


SELECT TOP 500 Results.VPath AS URL 
FROM OPENROWSET('MSIDXS', 'PSAJournals';''; '', 
'SELECT Rank, VPath FROM SCOPE(''deep traversal of "/journals" '') WHERE CONTAINS(''"<search terms>"'') > 0') AS Results
ORDER BY [Rank] DESC

If the search terms all happen to be stop-words, SQL 2005 generates the following error message:


OLE DB provider "MSIDXS" for linked server "(null)" returned message "The query contained only ignored words. ".

I was hoping it would simply return no rows, which seems to be what happens when using full-text searches on standard tables. The error is filtering up to the web-page and causing my site to break; is there any way I can catch it within my stored procedure and simply discard it (rather like try {} and catch {} in C#)?

All answers gratefully received,

Ed Graham

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources