try: Select Distinct A.Name From Test.dbo.SysObjects A Inner Join Test.dbo.SysColumns B ON A.ID=B.ID Where A.Xtype='U' And Exists(Select 1 From Orders.dbo.SysObjects Where Name=A.Name) And Not Exists (Select 1 From Orders.dbo.SysColumns Where ID=OBJECT_ID(A.Name) And (Name<>B.Name Or (Name=A.name And XType<>A.XType)))
Select Distinct A.Name From Test.dbo.SysObjects A Inner Join Test.dbo.SysColumns B ON A.ID=B.ID
Where A.Xtype='U'
And Exists(Select 1 From Orders.dbo.SysObjects Where Name=A.Name)
And Not Exists (Select 1 From Orders.dbo.SysColumns Where ID=OBJECT_ID(A.Name) And (Name<>B.Name Or (Name=A.name And XType<>A.XType)))