Conversion of max_rows_per_page to exp_row_size

If a table has max_rows_per_page set, and the table is converted from allpages locking to data-only locking, the value is converted to an exp_row_size value before the alter table...lock command copies the table to its new location. The exp_row_size is enforced during the copy.

If max_rows_per_page is Set to

Set exp_row_size to


Percentage value set by default exp_row_size percent


1, that is, fully packed pages

1 – 254

The smaller of:
  • Maximum row size

  • 2002/max_rows_per_page value