Regarding the clause "Where indid < 2", if you have a clustered index there will be a row in sysindexes with indid = 1. If you do not have a...

From my testing of these scripts, the row counts are only accurate if the table has a clustered index.

Gary

Cameron,

I am interested in the answer to Flavio's question since we have some views dependent on other views. Does it matter what order these views are refreshed?

Also, can you explain...