Article ID: 950437 - View products that this article applies to.
When you perform a search by using the Contains or Does not contain operators in Microsoft Office SharePoint Server 2007, you experience the following symptoms.
Note You can perform this search from the Advanced Search page by adding a property restriction as a search condition.
This problem occurs because expensive Transact-SQL queries are generated in this search scenario.
To resolve this problem, install hotfix 950280.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/950280/ )Description of the SharePoint Server 2007 hotfix package: March 21, 2008
Hotfix post-installation informationAfter you install the hotfix, the Advanced Search page does not display the Contains and Does not contain operators under the Search by properties section. This prevents users from creating expensive queries unintentionally.
To specifically enable the Contains and Does not contain operators, follow these steps:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Article ID: 950437 - Last Review: December 11, 2008 - Revision: 2.0