CRM 2015 – How to change max number of records per collection

Not the best thing to do in terms of performance probably, but if you need to increase the max number of records per collection, i.e: Rest call to get records and render as a table in a custom page, by default it will bring 50, to increase run the next sql statement in the MSCRM_CONFIG database:

update ServerSettingsProperties set IntColumn = 250  where ServerSettingsProperties.ColumnName = ‘MaxResultsPerCollection’

#MaxResultsPerCollection #RestAPI