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

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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:

904435 Update Rollup 2 is available for Microsoft CRM 1.2

MORE INFORMATION

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:

224453 INF: Understanding and resolving SQL Server 7.0 or 2000 blocking problems

271509 How to monitor SQL Server 2000 blocking

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:

824684 Description of the standard terminology that is used to describe Microsoft software

887283 Microsoft Business Solutions CRM software hotfix and update package naming standards