Applying max_rows_per_page to existing data

sp_chgattribute configures the max_rows_per_page of a table or an index. sp_chgattribute affects all future operations; it does not change existing pages. For example, to change the max_rows_per_page value of the authors table to 1, enter:

sp_chgattribute authors, "max_rows_per_page", 1

There are two ways to apply a max_rows_per_page value to existing data: