I’m full of SQL tips lately. I had a need to get a listing of the row count of all tables in a database. Here is a nice script I found somewhere that seems to do the trick.
SELECT sysobjects. Name, sysindexes.Rows
FROM sysobjects INNER JOIN sysindexes ON sysobjects.id = sysindexes.id
WHERE type = ‘U’ AND sysindexes.IndId < 2
ORDER BY sysobjects. Name