TSQL Script - To find no. of Rows in all tables of a database

sp_MSforeachtable @command1="print '?'", @command2="SELECT COUNT(*) AS '?' FROM ?"

See Also:

• T-SQL Scripts