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"

Article translations Article translations
Article ID: 925536 - View products that this article applies to.
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.
Expand all | Collapse all

On This Page

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: May 15, 2008 - Revision: 3.1
APPLIES TO
  • Microsoft CRM 3.0
  • Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers
Keywords: 
kberrmsg kbhotfixserver kbqfe kbmbsmigrate KB925536

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com