DROP TABLE DIFFERENCE1
DROP TABLE DIFFERENCE2

--RUN BEFORE BEFORE DATA CHANGE

SELECT  (SCHEMA_NAME(A.schema_id) + '.' + A.Name) AS TableName  
, SUM(B.rows) AS RecordCount  
INTO DIFFERENCE1
FROM sys.objects A  
INNER JOIN sys.partitions B ON A.object_id = B.object_id  
WHERE A.type = 'U'  
GROUP BY A.schema_id, A.Name  

--RUN AFTER DATA CHANGE


SELECT  (SCHEMA_NAME(A.schema_id) + '.' + A.Name) AS TableName  
, SUM(B.rows) AS RecordCount  
INTO DIFFERENCE2
FROM sys.objects A  
INNER JOIN sys.partitions B ON A.object_id = B.object_id  
WHERE A.type = 'U'  
GROUP BY A.schema_id, A.Name  

--SEE ROWS CHANGED
SELECT *  FROM DIFFERENCE1 LEFT JOIN DIFFERENCE2 ON DIFFERENCE1.TABLENAME=DIFFERENCE2.TABLENAME
WHERE DIFFERENCE1.RECORDCOUNT<>DIFFERENCE2.RECORDCOUNT