Diff 2 tables from different databases

script.sql

WITH A AS (
  SELECT *
  FROM OPENROWSET('SQLNCLI', 'Server=<SERVERA>;Database=CADIS;Trusted_Connection=yes;', 'select top 10 * from <TABLE>')
),
B AS (SELECT * FROM <TABLE>),

A_ONLY AS (
  SELECT TOP 10 * FROM A
  EXCEPT
  SELECT TOP 10 * FROM B
),
B_ONLY AS (
  SELECT TOP 10 * FROM B
  EXCEPT
  SELECT TOP 10 * FROM A
)
SELECT '<INSTANCEA>' AS SOURCE, '<TABLE>' AS TABLE_NAME, * FROM A_ONLY
UNION 
SELECT '<INSTANCEB>' AS SOURCE, '<TABLE>' AS TABLE_NAME, * FROM B_ONLY
ORDER BY CADIS_ID, SOURCE