Microsoft CRM may stop responding when you import or update many leads

When you perform one of the following actions in Microsoft Business Solutions CRM, the program may stop responding (hang):

• You import many thousands of leads at the same time.
• You update many hundreds of leads at the same time that you import many leads.
• You run a Microsoft CRM Software Development Kit (SDK) application that updates or inserts many leads at a time into the Organization_Name_MSCRM database.

This problem occurs because of a Microsoft SQL Server blocking problem. This problem occurs because the SQL Server scripts that perform INSERT, UPDATE, and DELETE statements run these statements on the SQL Server view and not on the database table.

Microsoft CRM has a fix for this problem that is part of a cumulative update. The cumulative update information is described in the following Microsoft Knowledge Base article:

This hotfix might not resolve all SQL Server blocking issues that you may experience. Some issue that you may experience might require additional troubleshooting by Microsoft Product Support Services (PSS). For more information, click the following article number to view the article in the Microsoft Knowledge Base: For more information about the terminology that is used to describe Microsoft product updates, click the following article numbers to view the articles in the Microsoft Knowledge Base: