Neil McDonald's Dynamics 365 Blog

Dynamics CRM 4 only allows users to view a maximum of 250 records per page within a view. This can be quite limiting when you need to run an on demand workflow against thousands of records.

There are 2 ways to get around this limit. The Microsoft supported solution is to use a plugin as described here. The unsupported and more risky workaround (and what I did…) is to update the organisation database directly as below.

UPDATE UserSettingsBase SET PagingLimit=1000 WHERE SystemUserId IN(Select SystemUserId from SystemUserBase WHERE FullName = 'neil mcdonald')

If using the SQL method, I recommend that you change it back to 250 rows or less once you’ve accomplished your tasks, as this is not supported by Microsoft and could cause errors with future updates.