Here is a way that help in getting all the table name and rowcount with in a database
The use can give the database name and it will show the output for that database.
Output can be ordered by name or by number of rows.
To use it :
Copy the script and run paste in QA and run.
[tested on SQL 7/2000]
When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.