Count rows number from database tables November 12, 2008

SELECT [TableName] = so.name, [RowCount] = MAX(si.rows)
FROM sysobjects so, sysindexes si
WHERE so.xtype = ‘U‘ AND si.id = OBJECT_ID(so.name)
GROUP BY so.name
ORDER BY 1 ASC