I need to compare row counts of all tables in two databases.
Each database is called OLAP. One on server A and one on server B
Want to list all tables that do not match on row counts
Please see this blog:
Counting Rows in All Database Tables in SQL Server
It has the script to counting rows in database tables.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?