Before you go through the trouble of scripting everything out make sure that your data is compatible with case insensitivity. You need to check all primary keys, and unique indexes...

You may want to try dbcc update usage with count_rows. Sounds like the catalog views may not be correct.

A snipit from BOL:

Reports and corrects pages and row count inaccuracies...

You need to bounce sql. The affinity mask is not dynamic.