select into and max_rows_per_page

select into does not carry over the base table’s max_rows_per_page value, but creates the new table with a max_rows_per_page value of 0. Use sp_chgattribute to set the max_rows_per_page value on the target table.