Neil McDonald's Dynamics CRM Blog

Get past the 250 records per page limit

with one comment

Screen_shot_2010-07-18_at_17

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')
Screen_shot_2010-07-18_at_17.57.36.png.scaled1000

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.

Written by neilmcd

July 18, 2010 at 4:43 pm

Posted in CRM 4

Tagged with , ,

One Response

Subscribe to comments with RSS.

  1. I have tried this query for change PagingLimit but when I open CRM from and see the value of Record Per Page in Option, it remain unchanged.

    Jigar bhatt

    November 21, 2014 at 5:55 am


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: