Microsoft Dynamics CRM 4.0 Paging Limit

Method 1:
From CRM UI, -> Set Personal Options -> Set the number of records shown per page in any list of records.
Method 2:
1. Run SQL script on CRM database
UPDATE UserSettingsBase SET PagingLimit=1000 WHERE SystemUserId IN
(Select SystemUserId from SystemUserBase WHERE FullName like 'user%')
2. Restart CRM web site and also clear user’s IE Cache


Method 3: To adjust the page limit to a value that is less than 5,000, add the MaxRowsPerPage DWORD Value to the registry. To do this, follow these steps:

1. Click Start, click Run, type regedit in the Open box, and then click OK.
2. Locate and then select the following registry subkey:
   HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM
3. On the Edit menu, point to New, and then click DWORD Value.
4. Type MaxRowsPerPage, and then press ENTER.
5. Right-click MaxRowsPerPage, and then click Modify.
6. Type a number that is less than or equal to 5,000 in the Value data box, and then click OK.
7. On the File menu, click Exit.

http://support.microsoft.com/kb/911510