Error message when you page through the results of a view that contains a column that has the ntext type: "A SQL Server error occurred. For more information, contact your system administrator Error Code: 0x80044150"

This article has been archived. It is offered "as is" and will no longer be updated.
The hotfix that is discussed in this article is not available for the Chinese version of Microsoft Dynamics CRM or for the Japanese version of Microsoft Dynamics CRM.
Symptoms
When you page through the results of a view that contains a column that has the ntext type, you receive the following error message in Microsoft Dynamics CRM 3.0:
A SQL Server error occurred. For more information, contact your system administrator Error Code: 0x80044150
This problem occurs after you sort the view results by the column that has the ntext type.
Resolution

Microsoft Dynamics CRM 3.0

This problem is fixed in Microsoft Dynamics CRM 3.0 Update Rollup 2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
927751 Update Rollup 2 is available for Microsoft Dynamics CRM 3.0

Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers

This problem is fixed in Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers Update Rollup 2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
944373 Update Rollup 2 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers is available
More information
You may have to perform additional steps if you have customizations that have an ntext field in the view. After you install the hotfix, you must remove the ntext field, publish the customization, and then add the ntext field to the view.

Note The following steps refer to the All E-mails view. However, you can follow these steps for any view.

To do this, follow these steps:
  1. Start Microsoft CRM.
  2. Click Settings, click Customization, and then click Customize Entity.
  3. Double-click E-mail, click Forms and Views, and then double-click All E-mails.
  4. Click the column that has the ntext type, click Remove, and then click OK.
  5. Click Save and Close.
  6. On the Actions menu, click Publish.
  7. Click Forms and Views, and then double-click All E-mails.
  8. Click Add Columns, click to select the check box for the column that has the ntext type, and then click OK.
  9. Click Save and Close.
  10. On the Actions menu, click Publish.
For more information about the terminology that is used to describe Microsoft software 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 updates
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards
Properties

Article ID: 925536 - Last Review: 01/15/2015 15:14:04 - Revision: 4.0

  • Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
  • kbnosurvey kbarchive kberrmsg kbHotfixServer kbqfe kbmbsmigrate KB925536
Feedback