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.
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.
A SQL Server error occurred. For more information, contact your system administrator Error Code: 0x80044150
Microsoft Dynamics CRM 3.0This 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:
(http://support.microsoft.com/kb/927751/ )Update Rollup 2 is available for Microsoft Dynamics CRM 3.0
Microsoft Dynamics CRM 3.0 Professional Edition for Service ProvidersThis 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:
(http://support.microsoft.com/kb/944373/ )Update Rollup 2 for Microsoft Dynamics CRM 3.0 Professional Edition for Service Providers is available
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:
(http://support.microsoft.com/kb/824684/ )Description of the standard terminology that is used to describe Microsoft software updates
(http://support.microsoft.com/kb/887283/ )Microsoft Business Solutions CRM software hotfix and update package naming standards