Displaying the expected row size for a table

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)