Tuesday, September 1, 2009

More than 10,000 records not returned by CRM service in MS CRM 4.0

There is a limitation in CRM service, when we retrieve data using
RetrieveMultiple or fetch xml; actually it returns max 10,000 records.

There is an unsupported way to increase the no of records returned by CRM service. You need to update the CRM DB.

There is a table named “OrganizationBase”, in this you have a column named “MaxRecordsForExportToExcel”, which defines the no of records returned by CRM service.

By default this column has been set to 10,000, which we can change according to our requirement.

Or we can use direct SQL query for the same.

1 comment:

crm services said...

Crm Services could really give aide to those people that have more tasks than everybody else. availing this CMS Solutions could get your life run a little smoother.Thanks for this very informative review. This seems to be very interesting, and very helpful for the readers.
Keep on posting!Crm Services