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

273 reads

Blogs

Daily Coping 18 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Optimize for Unknown for Inline Table-Valued Functions

By

I had a curious performance issue today. An inline table-valued function (iTVF) was performing...

Daily Coping 17 Sep 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to create a minimal tally table and to describe its advantages (if any)

By Steve Collins

What is the minimal way to create a tally table/tvf/cte and to describe its...

Need some help with log file

By Syed_SQLDBA

I have an issue with a log file which I am trying to solve....

Querying a table to get the columns with values

By mrodwell

Morning, i have a table with over 100 columns and i need to query...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers