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

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

Tracking History in Fact Table

By Niggles

Hi, I was hoping somebody would be able to offer advice in relation to...

How to get information about an AG group using powershell

By vsamantha35

Hi Experts, Does anyone has a powershell script which displays below information: for a...

Find out who stopped my SQL Services

By vsamantha35

Hi Experts, Is there a way to find out which windows user has stopped...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers