Article ID: 894315
Article Last Modified on 7/25/2006
APPLIES TO
- Microsoft CRM 1.2
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
Keywords: kbmbsmigrate kbpubtypekc kbqfe kbhotfixserver KB894315
