SELECT i.rowcnt, o.name 
FROM sys.sysobjects o JOIN sys.sysindexes i ON i.id = o.id 
WHERE o.xtype = 'U' AND i.indid IN (0, 1) 
ORDER BY o.name