An example using reorg rebuild to rebuild rows as part of the data movement, rebuilding mymsgs_test_reorg so that it is capable of storing in-row LOBs.
1> exec sp_drop_object mymsgs_test_reorg, 'table' Dropping table mymsgs_test_reorg (return status = 0) 1> 2> select * into mymsgs_test_reorg from mymsgs (9564 rows affected) 1> alter table mymsgs_test_reorg modify description in row (300) 1> 2> REORG REBUILD mymsgs_test_reorg Beginning REORG REBUILD of table 'mymsgs_test_reorg'. (9564 rows affected) REORG REBUILD of table 'mymsgs_test_reorg' completed. 1> 2> exec sp_spaceusage display, 'table', mymsgs_test_reorg All the page counts in the result set are in the unit 'KB'. OwnerName TableName IndId NumRows UsedPages RsvdPages ExtentUtil ExpRsvdPages PctBloatUsedPages PctBloatRsvdPages --------- --------------- ----- ------- --------- --------- ---------- ------------ ----------------- ----------------- dbo mymsgs_test_reorg 0 9564.0 1230.0 1242.0 99.03 272.0 373.08 356.62 dbo mymsgs_test_reorg 255 NULL 6.0 32.0 18.75 16.0 0.00 0.00 (1 row affected) (return status = 0) 1> 2> exec sp_spaceusage archive, 'table', mymsgs_test_reorg Data was successfully archived into table 'pubs2.dbo.spaceusage_object'. (return status = 0)