Join two result sets on different databases in SQL Server -

may question redundant posting not exact solution (please read actual scenario). have following script returns tables , corresponding no. of rows.

    select         sysobjects.name, sysindexes.rows             sysobjects         inner join sysindexes         on sysobjects.id = sysindexes.id             type = 'u'         , sysindexes.indid < 2 order ([rows]) 

now, want join result set similar result set on different database (with same structure). not able use 4 partition naming sysobjects. gives error: the multi-part identifier "my_database1.sysobjects.name" not bound.

actual scenario: have duplicate database , want know in tables data has not been moved original database.

any alternate solution help.

put .dbo between "my_database1. , sysobjects.name" in

my_database1.dbo.sysobjects