SELECT 
	tc.TableName, 
	tc.RecCount,
	st.row_count
FROM 
	TableCounts tc
	INNER JOIN  sys.dm_db_partition_stats st 
		ON tc.TableName = OBJECT_NAME(st.OBJECT_ID)
WHERE 
	st.index_id < 2
	AND tc.RecCount <> st.row_count;

--1
EXECUTE sp_MSforeachtable @command1 = N'
INSERT INTO ErrorCOunt(TableName, RecCount, ActualCount)
   SELECT TC.TableName, TC.RecCount, AC.ActualCount
     FROM (SELECT PARSENAME("?", 1) AS TableName, COUNT(*) AS ActualCount
             FROM ?) AS AC
          INNER JOIN
          TableCounts AS TC
          ON TC.TableName = AC.TableName
             AND TC.RecCount <> AC.ActualCount;';

--2
INSERT INTO ErrorCOunt(TableName, RecCount, ActualCount)
   SELECT TC.TableName, TC.RecCount, PS.actual_count
     FROM sys.objects AS T
          INNER JOIN
          TableCounts AS TC
          ON TC.TableName = T.name
          CROSS APPLY
          (SELECT SUM(CASE WHEN P.index_id < 2
                                AND A.type = 1
                                THEN P.rows
                           ELSE 0
                      END) AS actual_count
             FROM sys.partitions AS P
                  INNER JOIN
                  sys.allocation_units AS A
                  ON P.hobt_id = A.container_id
            WHERE P.object_id = T.object_id) AS PS
    WHERE T.type = 'U'
   AND TC.RecCount <> PS.actual_count;