Validate Source Table Row Count

Going back to SSMS within the jumpserver, copy the T-SQL script in a new query window, and execute:

Script:

SELECT 'dbo.Customers' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Customers  
UNION
SELECT 'dbo.Employees' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Employees
UNION
SELECT 'dbo.Products' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Products
UNION
SELECT 'dbo.Sales' As Table_Name, count(*) AS rows_count FROM sampledb.dbo.Sales;

Output:

Table Name Row Count
dbo.Customers 19759
dbo.Employees 23
dbo.Products 504
dbo.Sales 6715221

Screenshot: