You can check the forwrowcnt column in the systabstats table to see the number of forwarded rows for a table. This query checks the number of forwarded rows for all user tables (those with object IDs greater than 100):
select object_name(id) , forwrowcnt from systabstats where id > 100 and (indid = 0 or indid = 1)
Forwarded row counts are updated in memory, and the
housekeeper periodically flushes them to disk.
If you need to query the systabstats table using SQL, use sp_flushstats first to ensure that the most recent statistics are available. optdiag flushes statistics to disk before displaying values.
