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"

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: This problem occurs after you sort the view results by the column that has the ntext type.

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:

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:

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: