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:

If the table has a clustered index, drop and re-create the index with a max_rows_per_page value.
Use the bcp utility as follows:
1. Copy out the table data.
2. Truncate the table.
3. Set the max_rows_per_page value with sp_chgattribute.
4. Copy the data back in.