CRM 2011 – How to increase the records per page to more than 250 rows

I had an unusual problem today, I wanted to delete 3000 accounts which I had imported into a test organisation (to import them again without the missing data)

I thought I would do this using the advanced find but I could only delete 250 at a time.  So I decided to increase the row limit.  Unfortunatly there is no way to do this using the system so you have to adjust the setting on the SQL database table directly.  This is obviously unsupported so I would definetly think carefully about doing this on a customer site, also if you extended this value you will be retreiving more rows of data when using CRM and this will put more strain on the SQL server.

What I am saying is if you were to change this value for some end users CRM might start to work slower because you will be retrieving more records when you are viewing accounts, contacts, orders etc in CRM.

you need to open SQL Server Management Studio and then create a new query for the organisation database

{orgname}_MSCRM

here is the sql you need to run

SELECT SystemUserId, FullName FROM SystemUser WHERE FullName = 'your name'
e.g.
SELECT SystemUserId, FullName FROM SystemUser WHERE FullName = 'Ben Hosking'

then you use the guid value you have just retrieved and run the sql below
UPDATE UserSettings SET PagingLimit = WHERE SystemUserId = ''
e.g.

UPDATE UserSettings SET PagingLimit=1000 WHERE SystemUserId = '2A01D976-322E-E011-9645-00155D106B02'

You can set back the rows returned by using CRM and going into

FILE/OPTIONS

and then on the General tab you can set the Records per page