Get row counts from a corrupt database (via sys.objects)

GetRowCount.sql

DBCC UPDATEUSAGE(0) WITH COUNT_ROWS, NO_INFOMSGS 

 SELECT DBName       = DB_NAME(),
    SchemaName   = USER_NAME(so.UID),
    TableName    = so.Name,
    TableID      = so.ID,
    MinRowSize   = MIN(si.MinLen),
    MaxRowSize   = MAX(si.XMaxLen),
    ReservedKB   = SUM(CASE WHEN si.IndID IN (0,1,255) THEN si.Reserved       ELSE 0 END) * pkb.PageKB,
    DataKB       = SUM(CASE WHEN si.IndID IN (0,1    ) THEN si.DPages         ELSE 0 END) * pkb.PageKB
                    + SUM(CASE WHEN si.IndID IN (    255) THEN ISNULL(si.Used,0) ELSE 0 END) * pkb.PageKB,
    IndexKB      = SUM(CASE WHEN si.IndID IN (0,1,255) THEN si.Used           ELSE 0 END) * pkb.PageKB
                    - SUM(CASE WHEN si.IndID IN (0,1    ) THEN si.DPages         ELSE 0 END) * pkb.PageKB
                    - SUM(CASE WHEN si.IndID IN (    255) THEN ISNULL(si.Used,0) ELSE 0 END) * pkb.PageKB,
    UnusedKB     = SUM(CASE WHEN si.IndID IN (0,1,255) THEN si.Reserved       ELSE 0 END) * pkb.PageKB
                    - SUM(CASE WHEN si.IndID IN (0,1,255) THEN si.Used           ELSE 0 END) * pkb.PageKB,
    Rows         = SUM(CASE WHEN si.IndID IN (0,1    ) THEN si.Rows           ELSE 0 END),
    RowModCtr    = MIN(si.RowModCtr),
    HasTextImage = MAX(CASE WHEN si.IndID IN (    255) THEN 1                 ELSE 0 END),
    HasClustered = MAX(CASE WHEN si.IndID IN (  1    ) THEN 1                 ELSE 0 END)
FROM dbo.SysObjects so,
    dbo.SysIndexes si,
    (--Derived table finds page size in KB according to system type
        SELECT Low/1024 AS PageKB --1024 is a binary Kilo-byte
        FROM Master.dbo.spt_Values 
        WHERE Number = 1   --Identifies the primary row for the given type
        AND Type   = 'E' --Identifies row for system type
    ) pkb
WHERE si.ID = so.ID
AND si.IndID IN (0, --Table w/o Text or Image Data
                    1, --Table with clustered index
                255) --Table w/ Text or Image Data
AND so.XType = 'U'  --User Tables
AND PERMISSIONS(so.ID) <> 0 
GROUP BY so.Name,
        so.UID,
        so.ID,
        pkb.PageKB
ORDER BY TableName