• [font="Verdana"]Welcome. It's a good script, and modifying it was easy. 🙂

    I used to do this on SQL Server 2000, just by selecting from sysindexes with a script like the following snippet:

    select object_name(id) as [Table], Rows

    from sysindexes

    where indid in (0, 1) and object_name(id) not like 'sys%';

    You can do this with nolock on the table to see the rows building.

    However, I wanted to come up with something like that in SQL Server 2005, and had a bit of a play with it. Tracing the various connections between the system allocation tables turned into too much of a time waste at the time. But it turns out that you did the hard work for me!

    So again, a good script. Added to my toolbox.

    [/font]