use db1;

declare @result table (table_name sysname);
declare @sql nvarchar(max);

select
 @sql = t.x.value('.', 'nvarchar(max)')
from
 (
  select
   N'select ''' + b.table_name + N''' from (select checksum_agg(checksum(*)) from ' + b.table_name + N'except select checksum_agg(checksum(*)) from db2.' + b.table_name + N') t(cs); '
  from
   sys.tables a cross apply
   (select quotename(schema_name(schema_id)) + N'.' + quotename(name)) b(table_name)
  for xml path(''), type
 ) t(x);

insert into @result
 exec sp_executesql @sql;

select * from @result;

use db1;

declare @result table (table_name sysname);
declare @sql nvarchar(max);

select
 @sql = t.x.value('.', 'nvarchar(max)')
from
 (
  select
   N'select ''' + b.table_name + N''' from (select checksum_agg(checksum(' + f.columns_list + N')) from ' + b.table_name + N'except select checksum_agg(checksum(' + f.columns_list + N')) from db2.' + b.table_name + N') t(cs); '
  from
   sys.tables a cross apply
   (select quotename(schema_name(schema_id)) + N'.' + quotename(name)) b(table_name) cross apply
   (
    select
     ', ' +
     case type_name(c.system_type_id)
      when N'text' then N'cast(' + d.name + N' as varchar(max))'
      when N'ntext' then N'cast(' + d.name + N' as nvarchar(max))'
      when N'image' then N'cast(' + d.name + N' as varbinary(max))'
      when N'xml' then N'cast(' + d.name + N' as varbinary(max))'
      when N'sql_variant' then N'cast(' + d.name + N' as varbinary(max))'
      else d.name
     end
    from
     sys.columns c cross apply
     (select quotename(c.name)) d(name)
    where
     c.object_id = a.object_id
    for xml path(''), type
   ) e(x) cross apply
   (select stuff(e.x.value('.', 'nvarchar(max)'), 1, 2, '')) f(columns_list)
  for xml path(''), type
 ) t(x);

insert into @result
 exec sp_executesql @sql;

select * from @result;