SELECT so.name 'Table', si.rows 'Rows'
     FROM
          (SELECT Name FROM sysobjects WHERE type='U') so
     JOIN
          (SELECT rows,id,indid FROM sysindexes) si  
       ON si.id = OBJECT_ID(so.name) AND si.indid < 2

   DBCC UPDATEUSAGE (0)
 SELECT so.Name AS TableName,
        si.Rows AS [Rows]
   FROM sys.SysObjects so
  INNER JOIN sys.SysIndexes si
     ON si.ID    = so.ID
  WHERE si.IndID < 2
    AND so.XType = 'U'
    AND OBJECTPROPERTY(so.ID,'IsMSShipped') = 0

   DBCC UPDATEUSAGE (0)
 SELECT so.Name AS TableName,
        si.Rows AS [Rows]
   FROM dbo.SysObjects so
  INNER JOIN dbo.SysIndexes si
     ON si.ID    = so.ID
  WHERE si.IndID < 2
    AND so.XType = 'U'
    AND OBJECTPROPERTY(so.ID,'IsMSShipped') = 0