compare table counts in two databases

Sound like old hat ... but this procedure accepts the two database names as input parameters; therefore, it must dynamically generate the SQL and use Exec(@command) to execute it.   It also reports on tables that exist in one database but not the other ...  Finally, it uses count(*) to provide more accuracy than using sysindex […]

2003-10-24

272 reads

Blogs

Azure Storage tips

By

As a followup to my blog post Azure Data Lake Store Gen2 is GA,...

Managing Agent Jobs on Availability Group Servers

By

As always, the scripts in this post can also be found on our Git...

Permissions required for row counts to show up on Object Explorer Details

By

I ran into a rather obscure permissions problem the other day. Since I wasn’t...

Read the latest Blogs

Forums

On Looking and Acting the Part

By Phil Factor

Comments posted to this topic are about the item On Looking and Acting the...

How to make group by Revision_ID and when repeated display last check date separ

By ahmed_elbarbary.2010

problem How to make group by Revision_ID and when repeated display last check date...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers