CRM 4.0 – Exporting to Excel over 10000 rows

The power of exporting to Excel is one of CRM’s greatest functionalities. Often people bump their head against and internal limit of 10,000 rows set by the dev team to ensure you don’t receive a timeout error as SQL churns through the export process. How to solve the problem To change this in CRM 4.0: 1. Log-in to the SQL Server where the <Organization_Name>_MSCRM database is stored. 2. Open the OrganizationBase table. 3. Find the Column:  MaxRecordsForExportToExcel. 4. Change the value from 10,000 to the desired value. 5. Commit the change to the database. Additional Notes IISReset In order for … Continue reading CRM 4.0 – Exporting to Excel over 10000 rows