I need to make a list of all of the tables in an SQL Database and how many records are in each on.

I have no problem getting the list of tables (Thanks to help here on UT).

How do I get the total records in a table without having to open the table and wait until it goes to the bottom???

In SQL Server Enterprise Manager you just double click on a table and show structure and number of records.

Thanks