Article ID: 292755 - View products that this article applies to.
This article was previously published under Q292755
BUG #: 351773 (SHILOH_bugs)
Executing a full-text query from SQL Server Query Analyzer may result in the following error message:
The error occurs if the query uses the CONTAINS full-text search predicate and the search phrase meets the following criteria:
Server: Msg 7619, Level 16, State 1, Line 1
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
To keep the full-text catalogs from becoming bloated, words such as "is" and "the" are not stored in the catalogs and are ignored by full-text search. A list of these noise-words, in several languages, is in the Microsoft SQL Server\MSSQL\FTDATA\SQLServer\Config folder. These files are installed when the full-text search is installed.
You can edit the noise-word lists. However, before you edit the lists, you must stop the Microsoft Search Service. After the noise word list is edited and saved, the full-text catalogs must be repopulated for the changes to take effect.
The following script causes the error message to occur: