Use sp_help to display the expected row size for a table:
sp_help titles
If the value is 0, and the table has nullable or variable-length columns, use sp_configure to display the server-wide default value:
sp_configure "default exp_row_size percent"
This query displays the value of the exp_rowsize column for all user tables in a database:
select object_name(id), exp_rowsize from sysindexes where id > 100 and (indid = 0 or indid = 1)
