Help and Support
 

powered byLive Search

Expensive Transact-SQL queries are generated in the back-end instance of SQL Server when you perform a search in SharePoint Server 2007

Article ID:950437
Last Review:April 10, 2008
Revision:1.2

SYMPTOMS

On the Advanced Search page in Microsoft Office SharePoint Server 2007, you add a property restriction as a search condition. When you perform a search that is based on the property, the search may time out, or it may take a long time to finish.

When this occurs, expensive Transact-SQL queries are generated in the back-end instance of Microsoft SQL Server. This may cause a decrease in performance in the back-end instance of SQL Server.

Back to the top

RESOLUTION

To resolve this problem, install hotfix 950280.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:
950280 (http://support.microsoft.com/kb/950280/) Description of the SharePoint Server 2007 hotfix package: March 21, 2008

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Back to the top


APPLIES TO
Microsoft Office SharePoint Server 2007

Back to the top

Keywords: 
kboffice2007presp2fix kbexpertiseinter kbhotfixserver kbqfe kbbug kbfix kbpubtypekc KB950437

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.